LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How to Export as text file with NO delimiters or modifications?


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I export the contents of autoshapes to a text file? Donncha Excel Discussion (Misc queries) 1 July 20th 06 07:44 AM
saving an excel file as text without text in quotes John Excel Discussion (Misc queries) 2 December 6th 05 06:20 PM
Why can't I Export selected cells to tab-delimited text file? JE McGimpsey Excel Discussion (Misc queries) 1 November 28th 05 05:33 PM
export excel file as csv with text delimiter of " John Excel Discussion (Misc queries) 2 May 12th 05 05:50 PM
Convert text file to MS_Excel Aqua Flow Excel Discussion (Misc queries) 1 November 30th 04 02:55 AM


All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"