Get Similarity Percentage Between Two Text Cells in Same Row

[Galapagos15]

Is there a way to get the similarity percentage between text in two cells that are in the same row? I've tried Fuzzy Lookup but it doesn't compare the cells in the same row which is what I need. I know my last option is PWRSimilarity but I wanted to research free options first. Thanks in advance!

Example:

Column____________A_____________________B_________________________Need Similarity %?

Row#
1______________ABC Company___________ABC Co_______________________________? %
2______________John H. Smith___________John Harry Smith_______________________? %
3______________M. Jack Cole_____________Matt J. Cole___________________________? %
4______________Harry Adam Jacks_________H. J. Jacks____________________________? %
5______________IBI Company_____________Integrated Business Incorporated__________? %

 

[sheetspread]

pwrSIMILARITY - Office PowerUps

(never tried it though)


Oh sorry you know about it already (and presumably the 30 day free trial which may not be long enough for you)

 

[sheetspread]

This was someone else's VBA attempt:

http://www.mrexcel.com/forum/excel-...-applications-compare-strings-percentage.html

 

[Galapagos15]

That works...thank you!