Excel column comparision.

patilashish Posts 2 Registration date Wednesday December 9, 2015 Status Member Last seen December 9, 2015 - Dec 9, 2015 at 07:00 AM
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".