How to set new line char (Alt + enter ) in XL cell

[babuchelat]

I have some dynamic data coming, as XML like

<element> A B C</element>

 

I want to manipulate this XML element value while do an export to Excel file.

The value A, B and C should come in new lines in the same cell.

Is it possible to achieve this? Is it possible to set a new line char value as a part of data itself?

 

Thanks in advance,

Babu.

[jys]

<thatelement>.replaceAll(" ","n")

 

use string class type