what type of data is it.

I think fixed width is not a correct option for using text to columns.

for fixedwidth all the rows should have same width between fields.

can you paste or attach sample content.


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=373898