How 2 import text data into Excel from scanned text file ?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

anothrnub

Thread Starter
Joined
Sep 2, 2004
Messages
5
Good morning / Good afternoon
As a newbie I am making the first posting on your forum and I hope it is not a silly question.

I received a hard print of an excel spreadsheet with data in 9 columns (2 date formatted and 6 number formatted) of figures from my by bank and I wish 2 use them for further calculation. As I didn't get an electronic file from the bank I scanned the data sheet on the HP Scanner into text files ( rich text, plain text etc) and attempted to import the text into Excel; but I was unsuccessful. Have I attempted the impossible or did I do something wrong ?

If it is possible to do so how should I proceed ?
With thanks, anothernub
 
Joined
Jul 25, 2004
Messages
5,458
Hi,

If you have it as a text file, go to Data -> Import Data -> browse to file, import. You should be taken to the Text To Columns dialogue box where you can set the parameters of the import. Or you can upload the text file, if you'd rather.
 

anothrnub

Thread Starter
Joined
Sep 2, 2004
Messages
5
firefytr ty f y msge.
The data ->import data -> browse exercise is not working with my Rich Text or JPG files. I do not have plain text file because I am unable to save the scanned screen on plain text format. R U able to guide me on upload text file option ? Anyother alternatives ?
regards. anothrnub
 
Joined
Jul 25, 2004
Messages
5,458
Sure, when you hit post reply, click the manage attachments button. Browse to your file then be sure and hit the Upload button. Then just hit submit post.
 

anothrnub

Thread Starter
Joined
Sep 2, 2004
Messages
5
firefytr , Ty i'm back; probs not resolved yet. Re Ur Post 101; being new it is unclear. Is it 2 do with my query or a note on how 2 post on the TSG MB? Reverting back to my inquiry I managed to Data import the scanned WordPad text file into an Excel spreadsheet but not fully though. The WordPad is not wrapping round the rows with the result that some 50 rows on an A4 page end up in 3 or 4 rows on the WordPad extending to some 30/40 cms to the right of the file. Upon checking for the reason I note that there is no paragraph indentation limit on the WordPad. My attempt 2 amend the default setting has been a failure. While I am ploughing through the search results to find the answer, r u able to give a quick reply off the top of your head ?
Many thanks and with regards AnothrNewbie
 
Joined
Jul 25, 2004
Messages
5,458
If you can get the information to a text file (Notepad) then you should be ok. I don't know of a way to do it using WordPad. But if you uploaded the file, someone may be able to do it for you and explain how they did it.
 

anothrnub

Thread Starter
Joined
Sep 2, 2004
Messages
5
Hi Rollin and Hi frefytr. The plain text file that was saved from the RTF file that was produced by the HP scan is enclosed. note that I'm using Win XP on my PC and the Excel with the home is pretty basic and so I have a laptop on loan from a friend with XP professional for the Excel. Could it be that the WindowPad on XP home is also basic and causing me the hassle ?Thank you in advance for your assistance. Another newbie :)

P.S: the file since deleted
 
Joined
Jul 25, 2004
Messages
5,458
As commented from pm's:

If you go to View -> Options, and change the settings to No Wrap; or Insert -> Object -> Microsoft Excel Worksheet, can you paste into that; or Format -> Tabs -> Tab Stop Position, does changing that help?

Try these and let us know. I'm also posting this to the forum, it should be kept there, as to benefit all others (especially those w/ the same problem). :)



anothrnub said:
Firefyter Hi Rollin
That's what I wanted 2 do but the banker in charge of my account is on leave; also it was not one sheet but 6. the other option is I'm learning something.
Please tell me how could I amend or change the default setting on WordPad to have paragraphs indented for a width of 20.5 cm as opposed to the open ended position at present, because HP scans direct to the WordPad by pulling out a new sheet for each scan. So if I don't have default set up done properly I cannot stop the data filtering to 30/40 cm right of the files. Many thanks Anothernewbie

firefytr said:
Hi,

It would be my suggestion that you request an electronic file instead of a paper copy. This would prove quite extensive and mostly difficult the way you're trying to do it. Heck it may be faster for you to type it in manually compared to importing a text file in the format you posted. That would be my opinion anyway. Good luck! :)
 
Joined
Sep 13, 2004
Messages
1
can we import data from txt file into a word which is running some macro in it?how can we do it?tis will actually trigger the macro into creating a table which will store the txt data which has been inputted..any ideas.. (y) thxin ad
Shreya
 

anothrnub

Thread Starter
Joined
Sep 2, 2004
Messages
5
firefytr; ref yr post 115. Thank u for u'r comments. unfortunately the different exercises did not produce the results. i did a manual input of the data to sort my immediate problem and hence the delay in posting this message. My query is yet 2b resolved; i.e how will one import scanned Rich Text Format data (in 8 column by say25 rows) of 'date' and 'numerical values' into Excel ?' thnx anothrnub
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top