Help Importing Text File!
 

Hello,

I am new to excel and could really use some help. I have a plain text
file that I would like to import into Excel --but the problem is the
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 following
was copied like this:

Author Name
Location
Books Writen
Publisher

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

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

Thanks in advance.


--
traveler
------------------------------------------------------------------------
traveler's Profile: http://www.excelforum.com/member.php...o&userid=28226
View this thread: http://www.excelforum.com/showthread...hreadid=477781

Help Importing Text File!
 

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


€žtraveler€� ezt Ã*rta:


Hello,

I am new to excel and could really use some help. I have a plain text
file that I would like to import into Excel --but the problem is the
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 following
was copied like this:

Author Name
Location
Books Writen
Publisher

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

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

Thanks in advance.


--
traveler
------------------------------------------------------------------------
traveler's Profile: http://www.excelforum.com/member.php...o&userid=28226
View this thread: http://www.excelforum.com/showthread...hreadid=477781