Importing a text file

[hrithik]

I have a text file of the following format:

Author Title Edition/Type Qty Cond Price
------------------------------------------------------------------------------
A.A.WORLD SERV Alcoholics Anonymous 5 U 1.75
1-893007-17-0 4TH 01 PB

As you can see, the information has moved to a new line causing import problems.
How can I import this file in excel in the following format?

Author Title Edition/Type Qty Cond Price
------------------------------------------------------------------------------
A.A.WORLD SERV Alcoholics Anonymous 1-893007-17-0 4TH 01 PB 5 U 1.75

Please help!

 

[BrianB]

How strange, 2 consecutive messages with almost the same problem.

http://www.mrexcel.com/forum/showthread.php?t=486744

It is possible to do the job with an import macro, but it needs a bigger data sample.