matching one part of cell to another

Q

queenie

I want to match one cell that has partial name to another cell?

Ex. howardjohnson.com match to maybe Howard or Howard Johnson
 
P

Peo Sjoblom

You could test if Howard or Johnson is part of howardjohnson.com but the
other way around is not a good idea

=COUNTIF(A2,"*Howard*")=1

would return TRUE if A2 holds howardjohnson.com
 
Top