Excel importing text file as one long row

**NBVC** · 03-03-2009, 04:21 PM

I would suggest you delimit by semicolon into 1 row then copy that row go to the first cell you want to start the column in (can't overlap that original row, though) and do a Paste|Special >> Transpose... this will send it vertical.

**shg** · 03-03-2009, 04:25 PM

Or edit the text file and change the each semicolon to a carriage return & line feed.

**lhouk** · 03-03-2009, 06:51 PM

Originally Posted by NBVC

I would suggest you delimit by semicolon into 1 row then copy that row go to the first cell you want to start the column in (can't overlap that original row, though) and do a Paste|Special >> Transpose... this will send it vertical.

Not a bad idea, but my text file is so large that it generates more than 8192 columns, or whatever the maximum is, so I end up losing data.

Originally Posted by shg

Or edit the text file and change the each semicolon to a carriage return & line feed.

I hadn't thought of that approach; I could do that with vi, I suppose.

Thanks for the suggestions!