comparing text strings
Posted by carl on March 29, 2001 3:41 PM
I need a macro that will compare two words in adjacent columns and count how many letters the text strings have in common in the same serial position from left to right. For example:
The first row has two words (in different columns) that have two letters in common in the same serial position from left to right. The words in the second row also have two letters in common but these are not in the same serial position, in fact they only have one letter in common in the same serial poistion being the first letter d. I would like to run the macro in the third column (currently empty). Any ideas?