View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Confuddled User!!!!!!!!!!!!! Confuddled User!!!!!!!!!!!!! is offline
external usenet poster
 
Posts: 6
Default 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