Paragraphs in one Cell > HTML

[goble]

Hello,

am trying to convert an excel file to HTML. I have a few 100s of rows.

Serial No.	Name	Composition
1	Destadine Syrup	Each ml contains: Desratadine BP …….. 0.5 mg In a flavoured syrup base
2	Chlorphamine	Each ml contains: Frech BP …….. 0.5 mg In a flavoured syrup base

In D2, I have : ="<tr><td>"&A2&"</td><td>"&B2&"</td><td>"&C2&"</td></tr>".
To keep the line break, I need to use the <br> tag. So final results should be : <tr><td>1</td><td>Destadine Syrup</td><td>Each ml contains:<br>Desloratadine BP …….. 0.5 mg<br>In a flavoured syrup base</td></tr>
Note
(i) that there is no <br> after syrup base.
(ii) the cell C3 contains a blank line at the end

Replacing "CTRL-J" by <br> (in the column which contains the above formula) would simply add <br> in every cells so the result will be :
<tr><td>1<br></td><td>Destadine Syrup<br></td><td>Each ml contains:<br>Desloratadine BP …….. 0.5 mg<br>In a flavoured syrup base<br></td></tr>

Thanks for any recommendation here..

 

[Fluff]

Hi, what version of Excel are you using?

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[goble]

Hi and thanks,

I have updated my account details.

 

[Fluff]

Thanks for that, how about

+Fluff 1.xlsm
	A	B	C	D
1
2	1	Destadine Syrup	Each ml contains: Desratadine BP …….. 0.5 mg In a flavoured syrup base	<tr><td>1</td><td>Destadine Syrup</td><td>Each ml contains:<br>Desratadine BP …….. 0.5 mg<br>In a flavoured syrup base</td></tr
3	2	Chlorphamine	Each ml contains: Frech BP …….. 0.5 mg In a flavoured syrup base	<tr><td>2</td><td>Chlorphamine</td><td>Each ml contains:<br>Frech BP …….. 0.5 mg<br>In a flavoured syrup base</td></tr
Master

Cell Formulas
Range	Formula
D2:D3	D2	="<tr><td>"&TEXTJOIN("</td><td>",,SUBSTITUTE(LEFT(A2:C2,LEN(A2:C2)-1),CHAR(10),"<br>"))&"</td></tr"

 

[goble]

Thanks for that, how about

+Fluff 1.xlsm
	A	B	C	D
1
2	1	Destadine Syrup	Each ml contains: Desratadine BP …….. 0.5 mg In a flavoured syrup base	<tr><td>1</td><td>Destadine Syrup</td><td>Each ml contains:<br>Desratadine BP …….. 0.5 mg<br>In a flavoured syrup base</td></tr
3	2	Chlorphamine	Each ml contains: Frech BP …….. 0.5 mg In a flavoured syrup base	<tr><td>2</td><td>Chlorphamine</td><td>Each ml contains:<br>Frech BP …….. 0.5 mg<br>In a flavoured syrup base</td></tr
Master

Cell Formulas
Range	Formula
D2:D3	D2	="<tr><td>"&TEXTJOIN("</td><td>",,SUBSTITUTE(LEFT(A2:C2,LEN(A2:C2)-1),CHAR(10),"<br>"))&"</td></tr"

Thanks for your input.

However am getting for D2 = #VALUE!

 

[Fluff]

You may need to confirm the formula with Ctrl Shift Enter, rather than just Enter.

 

[goble]

Thanks Fluff for this magic Formula !

 

[Fluff]

You're welcome & thanks for the feedback.