string comparison

[22strider]

Hello Frieds

I need some help in comparing two columns having text strings.

I have two columns containing text strings (item descriptions). I am trying to compare these two description columns so that I can identify match and mismatch.
In addition to that I also need to do compare the two columns and quantify the difference. So that we have a information like it is 50% match or 60% match etc.

Thanks for your time

 

[mikerickson]

If we introduce two more names (respecting the relative addressing)

charOfA =MID(Sheet1!$A4&fillerStr, oneTo255, 1)
charOfB =MID(Sheet1!$B4&fillerStr, oneTo255, 1)

the combined formula becomes
=1-SUMPRODUCT(--(charOfA<>charOfB), --(charOfA<>fillerChr)+(charOfB<>fillerChr)) / (LEN($A4)+LEN($B4))