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