You're welcome!

Biff

"Kimberly" wrote in message
...
Thank you very much for your help!!

"Biff" wrote:

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

"Biff" wrote in message
...
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

"Kimberly" wrote in message
...
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!