breaking cell values based on New line

[sayadutt]

I have a cell value which consists of multiple new lines. My requirement is to break the values (retain all values) and have the substrings per cell. (I am reading cells from excel)

cell1 = test1

             test2

             test3

cell1 = test1

cell2=test2

cell3=test3

[Qlikas]

Use function SubField(Fieldname, chr(10)).