Hi all
I want to compare data of a 2 column but I want to know the what data exactly not matching.
I know the function "Exact" but its just giving whether the two cells are having same data or not.
I want to know which character causing mismatch.
Eg. A1 cell has data : I love excel forum
B1 cell has data : I lov excel forum
So when i compare A1 and B1 then I want excel should pop up that "e" is missing so causing mismatch in both cells.
Please treat this as high priority. Thanks in advance .
Bookmarks