PDA

View Full Version : Solved: Check if cell begins with number



realitybend
07-22-2008, 04:08 PM
Is there any way I can use an IF statement to see if a cell begins with a 2 (or a 3 or 4)?

Thanks

Bob Phillips
07-22-2008, 04:10 PM
=IF(LEFT(A2,1)="2","yes","no")

mdmackillop
07-22-2008, 04:13 PM
=IF(AND(--LEFT(A1,1)>1,(--LEFT(A1,1)<5)),TRUE,FALSE)

mikerickson
07-22-2008, 08:52 PM
= IF(AND(49<CODE(A1),CODE(A1)<53),"yes","no")

ilyaskazi
07-22-2008, 09:59 PM
With the below formula you will be able to check any number if exist...

=ISNUMBER(VALUE(LEFT(A1,1)))







...

realitybend
07-23-2008, 11:17 AM
Thanks for all your replies.