Detecting text and returning a value
You are welcome! Thanks for the feedback!
Stefi
Confuddled User!!!!!!!!!!!!! ezt *rta:
Many thanks Stefi, worked a treat
"Stefi" wrote:
=LEN(T(A1))0
returns true if text
false if nothing
Regards,
Stefi
Confuddled User!!!!!!!!!!!!! ezt *rta:
I am struggling with getting a return value of 1 or 0, or true or false from
a cell that conatins text.
I have text in one cell, what i need is to look at that cell, detect either
text or nothing and return the value of true/false, or 0 or 1.
Can anyone help???
Regards
|