View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrexcelnovice mrexcelnovice is offline
external usenet poster
 
Posts: 1
Default excel cell to html

I am using Excel 2003
I have a cell that I paste in a description.
Lets say the cell looks like this:

This item is new.
It goes real fast.
Batteries not included.

I want a formula in another cell so the output would look like this:

This item is new. <br
It goes real fast. <br
Batteries not included. <br

Of course the description cell has a lot more info, but I'm mainly after a
cell that will put in the break "<br" at the end of every line in the cell
so it will somewhat look on a webpage like I got in the excel cell.

Thankyou for your help!