Detecting text and returning a value
 

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

Detecting text and returning a value
 

=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

Detecting text and returning a value
 

Hi,

There are lots of ways to do this, here's one:

=IF(A1<"",TRUE,FALSE)

Where A1 is the cell that contains whatever (text in your case). I put this
formula in cell B1. You could also replace TRUE,FALSE with 0,1 or "There's
something","There's Nothing", etc...

hth

BigPig

"Confuddled User!!!!!!!!!!!!!" wrote:

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

Detecting text and returning a value
 

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

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

Detecting text and returning a value
 

=--(ISTEXT(A1))
--
David Biddulph

"Confuddled User!!!!!!!!!!!!!"
wrote in message ...
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

Detecting text and returning a value
 

Why not just

=ISTEXT(A1)
?
--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Stefi" wrote in message
...
=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