importing a scanned image

J

Julie

I am creating a mailing list in Excel by typing in the data. To save time, is
it possible to scan my hard-copy and import the data into Excel? The hard
copies come in various formats.
 
P

Peo Sjoblom

Yes it is possible if you have a good OCR reader that can transfer the
scanned image to text


Regards,

Peo Sjoblom
 
B

brdtim

This is something I have been trying to do, also. I can get the scanned data
converted through the OCR software into EXCEL, but it is then necessary to
cut and paste each item of each name, address and phone # to one line to
create a database record with info divided into fields. This takes more time
than just typing the original info into a contact record. Is there a way to
direct each line of the original record to a specific cell in EXCEL
automatically, and if so, HOW?
 
G

Gord Dibben

I would try scanning to a *.txt file then open the *.txt file in Excel and use
the Text Import Wizard

Or maybe you can just Data>Text to Columns on the already imported data?


Gord Dibben MS Excel MVP
 
L

lisa

--
the prize you paid for the life you choose, the prize will be paid for your
succes.
 
Top