Restrict cell entry of B1 as per the value in A1

C

cantus19

New member

Joined

Nov 1, 2015

Messages

2

Reaction score

0

Points

0

• Nov 1, 2015

• #1

I want to restrict value in cell B1 to Alphabets (and no numbers) if cell A1 value starts with "RA1". Could you please advise on the formula for this ?

 

N

navic

New member

Joined

Aug 27, 2013

Messages

901

Reaction score

0

Points

0

Excel Version(s)

Excel 2013

• Nov 1, 2015

• #2

Try

Code:

=IF(LEFT(A1;3)="RA1",TRUE,FALSE)

or

Code:

=IF(LEFT(A1;2)="RA",TRUE,FALSE)

 

N

navic

New member

Joined

Aug 27, 2013

Messages

901

Reaction score

0

Points

0

Excel Version(s)

Excel 2013

• Nov 1, 2015

• #3

sorry on error of formula (separator is wrong)

Code:

=IF(LEFT(A1,3)="RA1",TRUE,FALSE)

or

Code:

=IF(LEFT(A1,2)="RA",TRUE,FALSE)

 

C

cantus19

New member

Joined

Nov 1, 2015

Messages

2

Reaction score

0

Points

0

• Nov 1, 2015

• #4

Thanks Navic. Per the formula i am getting only true and false in B2 against i want to restrict numbers and only allow alphabets.