Formatting text in cells with html tags

[zesthealth]

hello , im hoping i can get some advice on a problem i have.

I need to be able to add a simple <p> tag to specific points in my text in excel cells. so for example some of my cells have product descriptions liek this

Goodio Raw Chocolate 56% Coffee 48g x 15
Starring sweet, smooth and powerful Espresso Verde organic coffee beans with cashew nuts for creamy taste.

the problem i have is that excel just sees that as one long string i.e

Goodio Raw Chocolate 56% Coffee 48g x 15Starring sweet, smooth and powerful Espresso Verde organic coffee beans with cashew nuts for creamy taste.

so what i need to do is add a <p> tag to the end of the 1st line so it woudl be soemthign like this in the cell

Goodio Raw Chocolate 56% Coffee 48g x 15<p>
Starring sweet, smooth and powerful Espresso Verde organic coffee beans with cashew nuts for creamy taste.




however , i cant do a find and replace as the text differs in each cell so was wodnering if there is a way to add the tag to a line break as in the exampel below.

hwo do i attach sample data in excel so that you can see what i mean ?

 

[pgc01]

Hi
Welcome to the board

Not clear.

I'll take a guess



I understand you have in a cell

1st line
2nd line
3rd line

and you'd like to add paragraph tags to post it in html, so that you have instead

<p>1st line</p><p>2nd line</p><p>3rd line</p>

If this is what you want you can use

="<p>"&SUBSTITUTE(A1,CHAR(10),"</p><p>")&"</p>"

is this what you want?

 

[zesthealth]

yeah looks good so far , thanks !

 

[pgc01]

You're welcome.