With these it helps I have excel sheet with 2 columns: baseline, current. , Found the answer.. no need for new column or so..
How do I find the position of the last alphanumeric character in an Excel string using an Excel formula?
By : Alex Valencia
Date : March 29 2020, 07:55 AM
With these it helps For example, in the string VA4940--05-LAMB --,%2--, 2 is the last alphanumeric character. It is in the 22nd spot. I'm looking for a formula that will return "22". , Alternate regular formula (no array entry required) solution: