Left Function

A

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?
 
M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
Macro to Select text from a point given to a specific word 2
Excel Functions 6
Determine if previous "character" is a section break 3
Problem with SET & REF function 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Need help modifying code 0

Top