Scan from a document to excel with separate cells
 

I have data sheets with a format that I need transfered into excel. What is
the best step by step process to copy the data into it individual cells. If
I copy and paste from pdf version all the data just goes into one cell.

Also is there a way to use a command to replace certain characters with
something else (ex: (...) to (0)?

thanks

Scan from a document to excel with separate cells
 

Shannon

With scanning the best way is to scan as a text file using your OCR application
that came with your scanner.

Open that text file directly into Excel.

There is usually some editing and manipulation needed in Excel.

For the replacing try EditReplace


Gord Dibben MS Excel MVP

On Fri, 5 Jan 2007 22:12:00 -0800, Shannon Y <Shannon
wrote:

I have data sheets with a format that I need transfered into excel. What is
the best step by step process to copy the data into it individual cells. If
I copy and paste from pdf version all the data just goes into one cell.

Also is there a way to use a command to replace certain characters with
something else (ex: (...) to (0)?

thanks