So you need to import a text file.
Row 1 needs to be parsed in one way.
Rows 2+ need to be parsed a different way.

I think I would do it like this:
1) Import file, placing column breaks where you want the 1st row
parsed.
2) Delete rows 2+
3) Import file again, placing column breaks where you want rows 2+
parsed and tell it to start import at row 2. Be sure to place the
imported file in the row below where you put the first row.

Will that work?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=518315