Forum Discussion
Solved
letter by letter comparison
Hi everyone, I need to compare the contents of a cell with a certain column. Let say we have a column with one character in each cell, I need excel to erase/delete (or change the filling color of) ...
I think I've done.. I hope so anyway.
Dear Mahmoud,
Sorry, but I said in the previous reply that you should first type it into the Full Text cell, and then test it in cell B1.
Dear Haytham,
Thank you, but it is the same.
If I put the fixed text in the (Full-Text Cell), it goes to the column, that is great ... then when I start comparing with the other text, which is actually not identical, that is the purpose of the comparison, what happens is that we get an empty cell each time we enter a non-identical letter, which is exactly the opposite of the demand, we need it to disappear when there is a match.
The two texts are not identical, the purpose of the comparison is to see how many letters are missing or extra.
Thank you a lot ... and yours
