Add a Newline Character

[#1]

Hi All,

I have a field value as ABC DEF.

I wish to convert it as ABC

                                  DEF.

How can I replace the space between the words ABC and DEF with a newline character.

Thanks,

Asma

[alexandros17 · Accepted solution]

replace ' ' with chr(10)

[robert_mika]

=Replace ('ABC DEF',' ',Chr(13))

[petter]

Where do you want to do it? In the load script or in the application in a chart at run-time?

Do you need it to show as separate rows in a table or is it in a Text Box?