Help Importing Text File!

[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

 

[Guest]

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


„traveler†ezt írta: