Calculate % or number of alphabets that are same in another cell

Closed
Tahir - Mar 16, 2015 at 09:10 AM
Hello,
How can we find out the number of alphabets of one cell that are same in another cell

For e.g. Cell A1=Tahir memon
And Cell A2= Qadri tahir
I want to find out in cell A3 that there are 5 alphabets which are same in both cells or 50% of A1 are equal to 50 % of A2