Formula to Separate String and Number into separate columns

Question

Hello,

I am trying to separate a number attached to a string into its own column. Here is a depiction of my current data:

The formula I have now (below) is not working on strings with double digit numbers attached:

This is my current output. As you can see, the formula only separates the last digit of a 2-digit number.

Can someone recommend another formula / approach to help me with this issue?

Thanks!

binu_acs · Answer

@shelbybradley  another option for extracting only strings

REGEX_Replace([Name], '[\d]+', '')

atcodedog05 · Answer

Hi @shelbybradley

Try this if you want to use formula tool only

Hope this helps : )

Split.yxmd

shelbybradley · Answer

Thanks - @binu_acs

I now have that ID in the new column, as shown below:

But how do I separate them so that the number is no longer is the "name" column like below?