Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Julie
 
Posts: n/a
Default importing a scanned image

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   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default importing a scanned image

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default importing a scanned image

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 328
Default importing a scanned image


--
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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Aspect ratio of image differs in print Monika Bjurman Excel Discussion (Misc queries) 1 April 29th 05 12:16 AM
my image in Excel inkjet printout has lines jennifer Excel Discussion (Misc queries) 3 March 20th 05 03:42 PM
Allow the pasting of a .jpg or other image file into a cell in Ex. Don Saunders Excel Worksheet Functions 1 January 28th 05 10:01 PM
image as a spreadsheet background melon Excel Discussion (Misc queries) 4 January 10th 05 05:48 PM
Importing XML data from http request Pau Larsen Excel Discussion (Misc queries) 0 December 2nd 04 02:01 PM


All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"