View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
viof viof is offline
external usenet poster
 
Posts: 1
Default How do I change text qualifier from double quote?

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?