Yes. See your later post.

Biff

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

"Biff" wrote:

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:



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!