Excel 2007 : Installing and editing a document

**Raner** · 01-09-2010, 12:39 PM

Hi
I am trying to install a text document I scaned it is loaded on my document folder on windows xp,I need to add it to execl spreed sheet and have it where I can edit and add some formulas to it can some one give me a few pointers.I can make it from scratch but it is going to take a long time to do it,I was thinking there might be a way around starting from scratch.Thanks Raner

**Richard Buttrey** · 01-09-2010, 01:41 PM

Hi,

If it's a scanned document (presumably with a .bmp, .tif, .jpg etc. extension) then to Excel, (or indeed any other software) the file is essentially a picture file and there's little you can do to use the data it contains.

If you have some OCR (Optical Character Recognition) software then you could process the scanned file and convert it back to a text file. Usually this is not 100% perfect since depending on the clarity of the scanned document not all text will be recognised.

Can you not get access to the original .txt or perhaps .prn file rather than an image of it? If you can you can open this as a file, copy the data into Excel, then use Excel's Text to Columns parsing feature.

HTH

**Raner** · 01-09-2010, 02:01 PM

Thanks for the comeback Richard
I'll see about getting a file convertion software tool of some sort because I don't have
access to the original file,but I do know how to make the document from scratch,but its a bit large so it will take a bit of time,but it's doable,and thanks again for taking the time to answer my post.Raner

**Richard Buttrey** · 01-10-2010, 08:37 AM

Hi,

There seem to be several shareware OCR software programs around - just Google OCR Shareware software. Hopefully you could use one of those to create a readable txt document which you can then plug into Excel.

Regards

**Raner** · 01-11-2010, 05:23 PM

Hey Richard What's Up
Well I got OmniPage Professional 17 it works like a champ. It has an Excel 2007 file convertion feature and a bunch of other ones,it is very easy to use and converts files Quickly,thanks for your help and got the document I needed to work on loaded and working on adding all the execution stuff I need to add for Excel 2007. Have a nice day Raner.