View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default New line Within CSV

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

"Mark League" wrote:

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