| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get Excel to open a document in a new Window ? NEW QUEST | Excel Discussion (Misc queries) | |||
| How to get separate Taskbar Buttons for each Excel Document? | Setting up and Configuration of Excel | |||
| Maintain proper links when Excel cells are moved | Excel Discussion (Misc queries) | |||
| copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
| Every second time i open Excel, it displays the document recovery pane | Excel Discussion (Misc queries) | |||
Hybrid Mode
