View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
sebh007 sebh007 is offline
external usenet poster
 
Posts: 5
Default Find text - worksheet function or macro?

It's OK thanks - cracked it! Just bracket it with an IF and I'm there -
sorry to trouble you.

S

"sebh007" wrote:

Sorry, but there's more. I get the resuLt 'TRUE' or 'FALSE' which is a great
help but there are other tests I wish to apply elsewhere so I need to be able
to say the equivalent of =IF(A2='TRUE',1,0) or similar. Although the display
in A2 is definitely 'TRUE' Excel doesn't recognise it as such. Is there any
way of utilising the 'TRUE' that is being returned in A2 please?

Thanks in advance.

S



"Max" wrote:

Pleasure` !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sebh007" wrote in message
...
Fantastic! Thank you so much!

S