Restrict cells entry to a-z / A-Z entry only

[shawthingz]

Hi!

I'm struggling to work out how to only allow a user to enter alpha characters (no digits) into a cell using the validation feature (so I can let them know if it's an invalid entry)

The string length is variable

Can anyone help?

Thx

shawthings

 

[pgc01]

Hi

Try:

Select A1 and enter in the data validation->custom->formula:

=LEN(A1)=SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(LOWER(A1),MID("abcdefghijklmnopqrstuvwxyz",ROW(INDIRECT("1:26")),1),"")))

Copy the validation to other cells as needed.