Looking for a formula or VBA for a condition: if in a cell first character is a letter and 2nd character is a number

[Mifti]

Hello,

Can I can get help in finding formula or VBA for a condition: If in a cell 1st character is a letter and 2nd character is a number then result is correct otherwise incorrect.

Appreciate this help in advance.

 

[Zot]

Say your data is in A1, then

=IF(AND(IF(ISERR(LEFT(A1,1)*1),0,1),IF(ISERR(MID(A1,2,1)*1),1,0)),"OK", "Not OK")

 

[Peter_SSs]

I think Zot might have the conditions the wrong way around?

Try this

20 12 22.xlsm
	A	B
1	abc	Not OK
2	a123	OK
3	2aed	Not OK
4	345ABC	Not OK
5	A2BC#4D	OK
Letter Number

Cell Formulas
Range	Formula
B1:B5	B1	=IF(AND(ISERROR(LEFT(A1,1)+0),ISNUMBER(MID(A1,2,1)+0)),"OK","Not OK")

 

[Zot]

I think Zot might have the conditions the wrong way around?

Try this

20 12 22.xlsm
	A	B
1	abc	Not OK
2	a123	OK
3	2aed	Not OK
4	345ABC	Not OK
5	A2BC#4D	OK
Letter Number

Cell Formulas
Range	Formula
B1:B5	B1	=IF(AND(ISERROR(LEFT(A1,1)+0),ISNUMBER(MID(A1,2,1)+0)),"OK","Not OK")

Looks like I did it again . And also just copy and not simplify it .... mind is on holiday already

 

[Mifti]

OMG! This help is incredible. Thank you all.

A little further help if you guys can: Only two characters ( 1st a letter and 2nd a number) are allowed in the cell. For example A14 would not be OK as has more than two characters.

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B
1	ab	Not OK
2	a1	OK
3	2a	Not OK
4	b#	Not OK
5	a23	Not OK
Main

Cell Formulas
Range	Formula
B1:B5	B1	=IF(AND(LEN(A1)=2,ISERROR(LEFT(A1,1)+0),ISNUMBER(RIGHT(A1,1)+0)),"OK","Not OK")

 

[Mifti]

Thanks much Fluff. It works as I want to be.

Happy Holidays ( if you have some) and Happy New Year to all and please stay safe!

 

[Fluff]

Glad we could help & thanks for the feedback.