Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I export the contents of autoshapes to a text file? | Excel Discussion (Misc queries) | |||
saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
Why can't I Export selected cells to tab-delimited text file? | Excel Discussion (Misc queries) | |||
export excel file as csv with text delimiter of " | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) |