Left Function

[AJ]

I am trying to pull certain characters based on a criteria for the third
position character.

In Column A, I could have a code such as BB11 or a Code such as BMR2. If
the third position character is a number then I only want to pull the first 2
digits BB but if the third position character is a letter, then I would like
to pull the first 3 characters BMR.

Can anyone help?

 

[Mike H]

Try this

=LEFT(A1,3-(ISNUMBER(MID(A1,3,1)+0)))

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.