Specific Characters

  • Thread starter Thread starter DarrenPWS
  • Start date Start date
D

DarrenPWS

Hi,

Is there a way that I ensure that a user only enters A-Z a-z an
special characters (therefore no numbers) into specific cells?

I would like an error message to appear if an INT is entered.

I though perhaps it would be in DATA > VALIDATION but could no
determine what I should use.

Thanks a lot
 
Hi
one way
goto Data validation and choose 'Custom' as category. enter the
following formula:
=NOT(ISNUMBER(A1))
if you want the validation to apply for cell A1

Frank
 
Custom Validation with the formula

=NOT(ISNUMBER(A1))

would not accept numeric input in A1, but would permit text that
includes digits.

Jerry
 
Back
Top