Data Validation for text only

K

Kimberly

I am wondering if anyone knows how to I can creat data validation for text
only - no punctuation. =istext allows punctuation. any suggestions? Thank
you!
 
B

Biff

Kind of ugly but it works:

=SUMPRODUCT(--(ISNUMBER(MATCH(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),ROW(INDIRECT("97:122")),0))))+SUMPRODUCT(--(ISNUMBER(MATCH(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),ROW(INDIRECT("65:90")),0))))=LEN(A1)

Biff
 
B

Biff

P.S.

That also excludes ALL numbers and ALL special characters.

The cell will only accept strings of A:Z and/or a:z.

Biff
 
K

Kimberly

Thank you very much for your help!!

Biff said:
P.S.

That also excludes ALL numbers and ALL special characters.

The cell will only accept strings of A:Z and/or a:z.

Biff
Click to expand...
 
K

Kimberly

I went to data validation, custom, and it does not allow me to enter this
formula. Am I correct in adding it in the custom information? Thank you!!
 
B

Biff

Yes. See your later post.

Biff

Kimberly said:
I went to data validation, custom, and it does not allow me to enter this
formula. Am I correct in adding it in the custom information? Thank
you!!
Click to expand...
 
Top