up vote 0 down vote favorite
share [g+] share [fb]

I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them with quotes, but Excel doesn't seem to recognize the CR character and puts a little box with a question mark in it instead. I can strip the CR's out of the CSV file, but it seems like an unnecessary step. Is there an easy way to get Excel to recognize a CRLF inside a row of a CSV file?

link|improve this question
feedback

2 Answers

up vote 0 down vote

This works for me:

first record,"line one
line two",1
second record,only one line,2

In other words, the first record takes up more than one line in the CSV.

link|improve this answer
For me, Excel correctly recognizes "line one line two" as a single cell, but places an unrecognized character marker just before the line feed. – Ben Fulton Sep 16 '10 at 19:58
This also works perfectly fine for me. No unrecognized character. Tested using Excel 2003. – wilson Sep 17 '10 at 1:30
feedback
up vote 0 down vote

It looks like just using vbLf is the answer. You are going to need to strip the carriage returns.

Take a look over at this StackOverflow question.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.