remove guotes from cells containing commas

H

hwalders

I have a column that contains commas. When saving as a tab delimited
txt file, excel puts the contents in quotes. I would like to somehow
have excel not put the quotes around the contents of that cell. I
could do a search and replace after opening in a text editor, however
that would remove quotes in columns that contain product descriptions
such as an item described in "(inches)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

open option for comma separated var file when commas missing? 3
Excel Save As Options 2
Excel VBA - Force 4 commas into a text field on userform 7
Selecting cells containing spcific character(s) 1
Turn a series of numbers in a cell into specific ranges 8
Saving As .CSV 9
problems when saving as comma delimited text file 1
Excel If a Cell Contains a Certain Text (From Another Table) 0

Top