Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default tab delimited and commas

dear all,
i wonder if you could help. i need to export a file as a tab delimited file
(can only be tab format), only some records contain text with commas, which
at the moment is being surrounded by quotation marks " ".

is there a way to prevent this, as there are thousands of records, and dont
want to use one method that was suggested of find and replace!!

many thanks,
suzie
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
Saving Excel sheet as a semicolon delimited file (.csv) e_dog95 Excel Discussion (Misc queries) 1 February 18th 06 11:02 PM
How do I fix a delimited file sent in Excel 2002? Robyn02 Excel Discussion (Misc queries) 6 February 14th 06 03:38 PM
Excel Quotation Marks! MaxFrance Excel Discussion (Misc queries) 6 March 29th 05 10:45 AM
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
Comma delimited bank info [email protected] Excel Discussion (Misc queries) 4 January 25th 05 10:55 AM


All times are GMT +1. The time now is 05:17 PM.

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"