Data Validation for text only
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!
|