Solved

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.

Best answer by gopalk2865

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

Thank you Gopalk. Beginner here. That was helpful.

Participating Frequently

You are welcome.

Sign up