newline character when exporting to Excel

J

Judy Ward

I apologize if this question has been posted/answered before. The "search"
feature for the message boards isn't working for me tonight.

I have a memo field in Access that includes line returns. When the data is
exported out to Excel the line return looks like two vertical bars when I
don't format the cells to wrap text. Only one vertical bar is displayed when
I format the cells to wrap text. I don't want to see any vertical bars! I
do want to keep the line returns (the equivalent of an Alt+Enter in an Excel
cell).

Has anyone already solved this problem? I would appreciate your help.

Thank you,
Judy
 
Top