I've just discovered that many of the character encodings have non-printable characters designed to separate different pieces of information, e.g., ASCII character 31 is the "unit separator". It seems that if I could use one of these characters as the separator in a "comma/character separated value" (CSV), I could avoid problems in escaping the values that could occur in text, e.g., commas.
Is it possible to make MS Excel (2007) use the "unit separator" instead of a comma? If so, how can I do that?
How can I enter the non-printable character? If I try searching for Unicode "001F" in the Character Map, I get a high-lighted blank box, and a "No Character Available" message, as shown below:
I'd rather not install a special program just to generate the non-printable character, but I can if I have to.