Query regarding splitting and replacing characters in a text

Hi,

I have a text as shown below:

"Number of students~20"

I would like to get the output in the following format:

Number of students

:20

Kindly help me with this. Thank you.

Participating Frequently

Hi , You can use a "Substitute" Function here and to change the line you can use Char(10). something like this

Participating Frequently

Hi , You can use a "Substitute" Function here and to change the line you can use Char(10). something like this

New Participant

Thank you Gopalk. Beginner here. That was helpful.

Participating Frequently

You are welcome.

Sign up