Data Validation for text only
 

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!

Data Validation for text only
 

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!

Data Validation for text only
 

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!

Data Validation for text only
 

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!

Data Validation for text only
 

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!

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!

Data Validation for text only
 

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!