Excel column comparision

Closed
Report
Posts
2
Registration date
Wednesday December 9, 2015
Status
Member
Last seen
December 9, 2015
-
Hey, I want to compare two tabs in separate columns with data which gives a match (Its okay if not exact) even though the words are jumbled or same. So, is there any formula to do this task? Eg:In Column A1 it is "PONDS WHITE BEAUTY FACIAL FOAM 50 g TUB" & column B1 has "Pond's Facial Foam - White Beauty, 50g Tube".