Search and Find

C

caveman.savant

If in Column A I have values like
PARTA25RED
PARTB526BLUE
PARTFR25GREEN
PARTYYT566RED

And I wanted to find the position of the 1st Numeric Value and
exclude any Alpha
would I use
ISNUMBER(FIND(LEFT(a1,1), {"ABCDEFGHIJKLMNOPQRSTUVWXYZ"})))
 
Top