New line Within CSV

M

Mark League

Hi guys,

I am pulling some results from an Oracle database and converting to a CSV to
present to a customer. Within one column I have several results seperated by
<BR>. This would be a new line within the cell but obviously is not working.
Does anybody know of a character that I can replace this <BR> with that will
make each record within that cell appear on a new line when opened in Excel?

Thanks,

Mark League
 
J

Joel

It should be <CR> for carriage return. You should be writing a line to add
the new line character.
 

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

I want to replace all "<br>" with a new line character. 2
replace new line character 3
["\r\n" new line command in CSV file] 1
Format Using vertical Line within Cell 1
importing a .csv so data on new lines? 2
Breaking a line within a formula - HELPHELP PLEASE 2
How to enter a return key stroke within a cell (new line of text) 1
new line within a cell 2

Top