Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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.

Context

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions