Formula to recognize text only in a cell
Brilliant!!
Tks,
Jim
"Duke Carey" wrote:
Maybe
=NOT(ISNUMBER(1*SUBSTITUTE(A1," ","")))
"Jim May" wrote:
In cells A1:A3 I have:
(as text)
Cell Values Formula Needed
0100 01029250 FALSE
0100 01029304 FALSE
0100 REHAB01 TRUE
I need a formula in Cells B1:B3
to Recognize is a cells has characters A-Z
I can't quite figure out here, under pressure...
Can someone assist?
|