If function -
Thanks very much
--
tia
Jock
"Toppers" wrote:
perhaps ..
=IF(ISNUMBER(FIND("Ford",A1)),"found","not found")
FIND is case sensitive, SEARCH is not.
=IF(ISNUMBER(SEARCH("Ford",A1)),"found","not found")
HTH
"Jock" wrote:
Can I use a 'LIKE' operator rather than the '=' one?
For instance:
=If(A1 LIKE "Ford", this,that)
If not, is there an alternative which will return partial matches?
--
tia
Jock
|