How do I change text qualifier from double quote?

G

Guest

In some cases data which I copy and paste into Excel contains double quote as
first character, Excel in this case treats tab delimiters as part of the
cell value and puts the whole string into one cell. In absense of double
quote it will use delimiters to parse text and put inot the multiple cells.
Is there a way to replace default text qualifier " with something else?
 
D

Dave Peterson

Any chance that opening the text file in a text editor and changing the double
quotes to an unused character (maybe |) and then importing that would work?

Then you could import the data and edit|Replace the | with what you
want--nothing or double quotes.

Might be worth a try.
 

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

Top