Kimberly

The formula does not go into a cell.....it goes into the Custom Formula dialog
box in DataValidationCustom

Just CTRL + C the formula from your post then CTRL + V into that dialog box.

NOTE: this formula is written to limit A1 only to text.

Adjust the cell ref if placing in other cells.


Gord Dibben MS Excel MVP


On Thu, 9 Nov 2006 10:26:01 -0800, Kimberly
wrote:

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)