Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Craig Hilliard
 
Posts: n/a
Default saving excel file as tab delimited

Has this bug been addressed? Saving a sheet as tab-delimited text should not
alter the data in any cells.


"kirshru" wrote:


i am trying to save a excel file , and one of the cells in the file has
a string with a ',' and when saved as a tab delimited file , ""[Double
Quotes] are printed around the string that was in the cell.

EG:

NOTE: If conduit is needed*, it * must be in place before vendors are
dispatched to complete any site work

when saved as tab delimted file is saved as

\" [/b] NOTE: IF CONDUIT IS NEEDED, IT MUST BE IN PLACE BEFORE VENDORS
ARE DISPATCHED TO COMPLETE ANY SITE WORK[b]\".

I do not want to see double quotes around the string in the tab
delimited file.

A


--
kirshru
------------------------------------------------------------------------
kirshru's Profile: http://www.excelforum.com/member.php...o&userid=14778
View this thread: http://www.excelforum.com/showthread...hreadid=263987


Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
save an Excel worksheet as a comma delimited file? Trophy Man Excel Discussion (Misc queries) 2 January 8th 05 03:11 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM
Opening and saving Excel 2003 file from Excel 97. Rodrigo Excel Discussion (Misc queries) 2 December 12th 04 02:17 PM


All times are GMT +1. The time now is 01:40 PM.

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

About Us

"It's about Microsoft Excel"