C# export to excel replace <br/> with a line break in a cell

Question

I'm exporting data to excel. Is it possible to replace <br/> in a string with a line break (alt+enter) so that when exported to excel the string is displayed on separate lines in the same cell.

For example:

string text = "Number One" + "`<br/>`" + "Number Two"

Excel:

Number One
Number Two

Answer 1

Only what you need it's add style="mso-data-placement:same-cell;" inside <br /> tag. Data will be displayed on separate lines but in the same cell.

<br style="mso-data-placement:same-cell;" />