How do you do this?
in A1
John Andersson
or
Peter Johnsson
or
Peter johnsson
If i want to find if there is a occurence of "john" inside these strings how do I do that??
IF(A1=contains("john"),"true","false")
should return the value "true" for both above.
is this possible?? Is there some kind of "contains" functionality??
/J
Bookmarks