identify data in a cell that has a number as the second character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

In a particular range of cells I have a drop down list that allows me to
pick from the following: 1b14, 1a14, 2a15, 2a15, 3a14,3b15, P1, P2, P3, P4

I have the forlmula that states if data starts with a number then return a
certain cell.

how would I write, If in range b1:c:4, the data's second character is a
number then return A1?
Thank You,
Brian
 
One way, array-entered (CTRL-SHIFT-ENTER or CMD-RETURN):

=IF(OR(ISNUMBER(-MID(B1:C4,2,1))),A1,"")
 

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

Calculating number of periods 2
Counting the number of times a character occurs in a cell 1
Count the times a specific character appears in a cell 3
Masking out characters in a cell 9
How do I create a drop down box within a drop down box? 1
To combine various cell formulae in to the final cell 1
counting no. of times a character occurs in a cell 3
count no. of times a character occurs in a cell 2

Back
Top