matching one part of cell to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ex. howardjohnson.com match to maybe Howard or Howard Johnson
 
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
 
Back
Top