Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can the SUBSTITUTE function replace a double quote? | Excel Worksheet Functions | |||
excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
Double quote delimiter script | Excel Worksheet Functions | |||
Exporting single or double quote delimited files | Excel Worksheet Functions | |||
how do I create comma and double quote delimited file | Excel Discussion (Misc queries) |