View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default New line Within CSV

Edit/ Replace
Find what: <BR
Replace with : Control-J
--
David Biddulph

"Mark League" <Mark wrote in message
...
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