ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   saving excel file as tab delimited (https://www.excelbanter.com/excel-discussion-misc-queries/11041-re-saving-excel-file-tab-delimited.html)

Craig Hilliard

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




All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com