Splitting numbers from text

[Ahasan13]

Hi all,

I am trying to split numbers from text for example I have this "1000 NexTier Checking (deleted)" I need to make a column for Just the number which is "1000" and another column for the text which is "NexTier Checking (deleted)" How do I do that? also Not all the numbers are 4 digits. Please help

[ShankerV · Accepted solution]

Hi @Ahasan13 

Are you looking for the output like below.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V