how can i convert text file to excel file ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a text file 400 pages long, i need only certain information (loan
amount, interest rate, principal amount) to transer to an xls file, so i am
able to create formulas and copy and paste information i need. we are
retyping it at work from txt file to an xls file, and it is a pain.
thanks
 
Particularly if you edit your file down to a table of data (hopefully with
column headers!), Excel may astound you with its intuition. From Excel's
menu bar, File > Open. In the dialog, set the 'files of type' drop-down at
the bottom to 'text files.' Then find your file and open it. Again, if the
file content is a table, Excel will perform once of those rare 'do what I
mean' tricks.
--Bruce
 
bpeltzer said:
Particularly if you edit your file down to a table of data (hopefully with
column headers!), Excel may astound you with its intuition. From Excel's
menu bar, File > Open. In the dialog, set the 'files of type' drop-down at
the bottom to 'text files.' Then find your file and open it. Again, if the
file content is a table, Excel will perform once of those rare 'do what I
mean' tricks.
--Bruce
Click to expand...
When you do the file open as suggested you will get a text import wizard.
You need to select fixed length or delimited as required. Excel will make
a choice based on the file structure. It's not always right. If you select
fixed width it will let you set the column width. Delimited will set
the width base on a character or space. You can also mark columns not to be
imported so you don't get any unwanted data. Make sure to keep a copy of
your text file intact. You may have to experiment a bit to get the results
you need. Post back if you need more help.

gls858
 
Back
Top