ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   tab delimited and commas (https://www.excelbanter.com/excel-discussion-misc-queries/102243-tab-delimited-commas.html)

sedonovan

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


All times are GMT +1. The time now is 11:08 AM.

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