Alphanumeric number parse to just the alpha

I have a column with an alphanumeric number "CYG2525" or it could be "C2525", "GY2525". As you can see the alpha can range in the amount.

I need to be able to pull over just the letters so "CYG" or "C" or "GY" for example. I thought I could do this with saying give me everything left of the "2" but the issue would be when there is more than one "2" in the number.


Alpha = Region

Number = Identifier

We have updated our form for any new submission to pull into these new cells with a drop down for Region and a number only field for identifier so we are good with going forward just need to convert all our existing data.

Thanks for the help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!