"/r/n" CSV file In Excel
 

[Briefing]
I got an Project export Text into the CSV file type.

However i face a problem that if my CSV data contain multiple line(eg : "
sleep\r\nHello\r\n"), and open this in the CSV file. We notice that a empty
space is appended behind the new line.

[Result]
sleep<Space
Hello<space


If i open this CSV file with notepad, this issue doesnt happen.


[Research]
I had do some similar research

1. Open Outlook contact, at the address field, i break the address into a
few line and export the contact into the CSV file.
- The Outlook CSV file having the same behavior as mention above

2. Open a Notepad and type below text into the notepad.
"CAV

CAV@

CAV@"

and save the notepad into the csv type and then open the CSV file with excel.

- The notepad CSV file also having the same behavior as mention about.


[Question]
why excel appended an empty space behind the "\r\n"? It is a bug for excel?