LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike521
 
Posts: n/a
Default Saving as Text (tab delimited) surrounds text with "quotes"


Hi all,

I'm trying to save an excel file as a tab delimited text file. I do not
want to use quotes as a text qualifier. However, certain fields in the
file (fields with large amounts of text) are automatically being
surrounded in quotes by excel.

So let's say I have a spreadsheet with two columns, 1 row, that reads:

data | data data data data

All I have to do is open this and save it as a text file, and Excel is
automatically changing the text file to read:

data | "data data data data"

Using Excel 2003

can anyone help solve this annoying problem?


--
Mike521
------------------------------------------------------------------------
Mike521's Profile: http://www.excelforum.com/member.php...o&userid=35206
View this thread: http://www.excelforum.com/showthread...hreadid=549719

 
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
Import comma delimited text Lin Excel Discussion (Misc queries) 3 July 28th 06 04:07 PM
I have a Comma delimited text file how do I import in to excel an. trevord Excel Discussion (Misc queries) 1 February 3rd 05 11:41 PM
saving excel file as tab delimited Craig Hilliard Excel Discussion (Misc queries) 0 February 1st 05 10:39 PM
Saving as a csv file with text qualifiers Rajendra Pai Excel Discussion (Misc queries) 2 January 18th 05 07:45 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 03:34 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"