G
gill
I want to be abel to ensure a cell contains only letters
of the alphabet and not numbers -is there any way to do
this please?
of the alphabet and not numbers -is there any way to do
this please?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Assuming you meant that the whole string must be letter only like
abcd
and not
ab2cd
do data>validation>custom and use this formula
=ISNA(MATCH(TRUE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0))
that will prevent people entering numbers in strings
in cell A1 (adapt to fit)
If you meant only one number or one letter
k
but not
5
the above works as well but then you could use a simpler formula
=NOT(ISNUMBER(A1))
abcd
and not
ab2cd
do data>validation>custom and use this formula
=ISNA(MATCH(TRUE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0))
that will prevent people entering numbers in strings
in cell A1 (adapt to fit)
If you meant only one number or one letter
k
but not
5
the above works as well but then you could use a simpler formula
=NOT(ISNUMBER(A1))
G
gaftalik
Hi Gill ,
Select the cell or range of cells you want , choose data from your menwrite =istext("your selected cell or range of cells" ) and then clic
ok .
P.S : in Error tab under error message you may write what you want a
an message when you edit numbers in your selected cells by mistake
Good luck !
Gaftalik
Select the cell or range of cells you want , choose data from your menwrite =istext("your selected cell or range of cells" ) and then clic
ok .
P.S : in Error tab under error message you may write what you want a
an message when you edit numbers in your selected cells by mistake
Good luck !
Gaftalik
K
Ken Wright
This will still allow 'numbers in text' if the title is taken literally, as
abc2def is a text value. Peo's solution however, would prevent this.
abc2def is a text value. Peo's solution however, would prevent this.