Thank you both! Thanks Biff - I didn't know how else to respond to you.

"Biff" wrote:

Here's a sample file with this implemented:

Data Validation.xls 14.0kb

http://cjoint.com/?ljukUJHGNl

Biff

"Kimberly" wrote in message
...
I was given this formula and I am trying to enter it in a cell to only
allow
the user to enter text howerver it does not fit. Any suggestions?
=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)