hello all,
I am simply trying to save a sheet as a text file with the column
contents saved as a simple long string of data, regardless of content.
Ex. If my columns were this: (underscores represents columns, the pipes
and ampersands are actual cell content).
a213_____|_____text1_____&_____14.44000_____|_____ endtext
I would want the text file to read:
a213|text1&14.44000|endtext
None of the "Save As" choices allow this. All end up with at least
tab's separating the original cell contents. Also tried changing the
delimiter in the control panel, but NULL is not an allowed choice. And
opening the csv in any text editor still has tabs as separators
anyway.
Thanks
Scott
--
MojoNixon
------------------------------------------------------------------------
MojoNixon's Profile:
http://www.excelforum.com/member.php...o&userid=37251
View this thread:
http://www.excelforum.com/showthread...hreadid=569672