View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I change text qualifier from double quote?

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.

viof wrote:

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?


--

Dave Peterson