| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning Text | Excel Discussion (Misc queries) | |||
| Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
| returning specific text only | Excel Worksheet Functions | |||
| Detecting Case of Text in a Cell | Excel Discussion (Misc queries) | |||
| Detecting Blanks and Non Text Characters. | Excel Worksheet Functions | |||
Hybrid Mode
