Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import comma delimited text | Excel Discussion (Misc queries) | |||
I have a Comma delimited text file how do I import in to excel an. | Excel Discussion (Misc queries) | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) | |||
Saving as a csv file with text qualifiers | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |