Hi:
I agree with Peter. There's no guarantee, that even if Escapechar did work for changing style, etc, that Escapechar+n would write the same thing that Excel writes for the Alt+Enter (which is what you have to use to put a return into an Excel cell -- outside the world of SAS.)
In fact, when I made a test spreadsheet and saved the file as XML, this is what I got from Excel (in the XML) for the cell:
[pre]
ccc ddd |
[/pre]
It looks to me like is some kind of named entity (like ) that represents ALT+Enter.
It also looks like Excel is setting the Wrap attribute on the s21 style:
[pre]
[/pre]
But, when I tried to use that string in a cell, even with protectspecialchars=off, Excel did not translate my to a return. Perhaps there is a hex code equivalent of that string which would work better. I frequently find that some things Microsoft does in its own XML I am unable to duplicate.
cynthia