I am trying to import a TAB delimited file with the following format into Excel 2013
"Column A" "Column B"
"tjc0056421151r" "I\gs]hü"nsf^f\F*lqog\düûWp"
"tjc0058088269r" "EZacð0jrzmnbofofBÖÞRlXZi")["
When importing into Excel, the following format appears
Column A Column B
tjc0056421151r I\gs]hünsf^f\F*lqog\düûWp"
tjc0058088269r EZacð0jrzmnbofofBÖÞRlXZi)["
Example #1
In B1 you will notice that the " has disappeared here:
hü"ns
and is now
hüns
Example #2
And in B2 you will notice that the " has disappeared here:
XZi")["
and is now
XZi)["
Excel has assumed that because there is a " in the value, that this is the closing " of the value, and has therefore stripped it. The actual " at the end of the value, which should have been stripped, has remained.
Is there any option in Excel which prevents this from happening?