Splitting Number and Word

[SH_94]

Dear community,

I would like to ask how can we split the number and wording into two different columns. Below is the screenshot of input and result wanted.

Many thanks again for the help.

[atcodedog05 · Accepted solution]

Hi @SH_94 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @SH_94 

Cheers and have a nice day!