"/r/n" CSV file In Excel

C

Cathy

[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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

["\r\n" new line command in CSV file] 1
Excel VBA macro to auto import new CSV file from fixed directory 1
Quotes in a csv file 3
How write into text file at first and last line with excel vba? 3
Forcing Excel to Import .CSV data 2
copy recordset to CSV file 1
Reading data from CSV file 4
save(append) to an excel file 3

Top