Scan from a document to excel with separate cells

S

Shannon Y

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
 
G

Gord Dibben

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 Edit>Replace


Gord Dibben MS Excel MVP

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