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