Help Importing Text File!

  • Thread starter Thread starter traveler
  • Start date Start date
T

traveler

Hello,

I am new to excel and could really use some help. I have a plain tex
file that I would like to import into Excel --but the problem is th
text was copied from a webpage and there is no delimited formatting
(extra spaces, lines etc.)

i.e. I want to create a book database with this info. But the followin
was copied like this:

Author Name
Location
Books Writen
Publisher

I would need to somehow put each line into a column. This is a hug
text file formatted like the example above. Could this be done possibl
by using a macro?

If anyone could help me out (or if you need more info) please reply.

Thanks in advance
 
Could you give an example of the text file and of the desired .xls table
including headers, etc.
Stefi


„traveler†ezt írta:
 
Back
Top