Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |