Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
Yes it is possible if you have a good OCR reader that can transfer the
scanned image to text Regards, Peo Sjoblom "Julie" wrote: 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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? "Peo Sjoblom" wrote: Yes it is possible if you have a good OCR reader that can transfer the scanned image to text Regards, Peo Sjoblom "Julie" wrote: 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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 DataText to Columns on the already imported data? Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 06:48:01 -0700, brdtim wrote: 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? "Peo Sjoblom" wrote: Yes it is possible if you have a good OCR reader that can transfer the scanned image to text Regards, Peo Sjoblom "Julie" wrote: 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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() -- the prize you paid for the life you choose, the prize will be paid for your succes. "Gord Dibben" wrote: 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 DataText to Columns on the already imported data? Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 06:48:01 -0700, brdtim wrote: 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? "Peo Sjoblom" wrote: Yes it is possible if you have a good OCR reader that can transfer the scanned image to text Regards, Peo Sjoblom "Julie" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Aspect ratio of image differs in print | Excel Discussion (Misc queries) | |||
my image in Excel inkjet printout has lines | Excel Discussion (Misc queries) | |||
Allow the pasting of a .jpg or other image file into a cell in Ex. | Excel Worksheet Functions | |||
image as a spreadsheet background | Excel Discussion (Misc queries) | |||
Importing XML data from http request | Excel Discussion (Misc queries) |