ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel cell to html (https://www.excelbanter.com/excel-discussion-misc-queries/104602-excel-cell-html.html)

mrexcelnovice

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!


All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com