Mike,

No, you need to use VBA, unless the file is less than 256 lines, in which case you could import it
to one cell (subject to the limitation of 32K characters), use Data / Text to columns, and then
transpose the resulting cells.

HTH,
Bernie
MS Excel MVP


"mikewilsonuk" wrote in message
news:mikewilsonuk.29dyt0_1150278305.6441@excelforu m-nospam.com...

Is there a way to import a text file with no line delimiters without
resorting to VBA? The file I need to import has field-width fields
padded with spaces. The first field of the next row starts immediately
after the end of the last field of the previous row -- there is nothing
to indicate the end of a line/record.

I have used the import wizard to import similar files with line
delimiters and it does just what I need. If there is a way to do the
same thing with this wretched delimiter-free file, I will be very
pleased to hear it.


--
mikewilsonuk
------------------------------------------------------------------------
mikewilsonuk's Profile: http://www.excelforum.com/member.php...o&userid=35404
View this thread: http://www.excelforum.com/showthread...hreadid=551781