Dave Peterson Wrote:
Not so random...

http://support.microsoft.com/default.aspx?scid=77295
Column Delimiters Missing in Spreadsheet Saved as Text

(It actually describes missing delimiter, but if some are "missing",
maybe the
ones appearing are "extra".)


Ahh ...I was (slowly) coming to a 'similar conclusion'
(http://www.excelforum.com/showthread.php?t=564635). The length of the
header determines the extra columns in the first few rows.

Dave Peterson Wrote:
Maybe you could write your own exporting program that would behave
exactly the
way you want

Cheers ...this is the Babylon 5 ('last, best hope') option ;-)

Dave Peterson Wrote:
(or maybe you could build your own formula and copy|paste that single
column
into Notepad--and save from there.)

This is my favourite quick and easy method for personal use.


--
lucidr
------------------------------------------------------------------------
lucidr's Profile: http://www.excelforum.com/member.php...o&userid=36699
View this thread: http://www.excelforum.com/showthread...hreadid=564338