Looking for a 'Contains' Formula in Excel

[Rich]

I would like to use a 'contains' formula in excel which would return TRUE or
FALSE, however I can' t seem to find one..

Can anyone create a simple Function Procedure that I can use in excel which
would take two inputs, and compare them to see whether one string is
contained in the other and return TRUE or FALSE if there is a match back to
the spreadsheet?

Many thanks

Rich

 

[Rich]

I should add that it should be able to handle a formula something like
this..

=CONTAINS(OR(A1,A2,A3,A4),B1)

Where B1 is the reference cell, and the cells being checked are A1,A2,A3 etc

or alternatively

=OR(CONTAINS(A1,B1),CONTAINS(A2,B1)) etc
.....

 

[keepITcool]

try functions:
FIND case sensitive
SEARCH case insensitive

alas.. as most excel functions.. instead of returning
a 0 if not found it returns Value#.. so wrap in if(iserror(),,)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rich wrote :