Dear Gurus,
i have a simple table
Column A
cell A2 text Value "Soren Petersen"
Column B
Cell B2 text Value "Soren Petersan"
since there is a difference in the second last alaphabet which in Col A it is "e" character and Col B it is "a" character
i want in Column C
Cell C2 to show extracted the difference. either to show the difference character or perhaps if it just indicate what number of characterwithin the text does not match from column B to COlumn A.
would appreciate your feedback
i have a simple table
Column A
cell A2 text Value "Soren Petersen"
Column B
Cell B2 text Value "Soren Petersan"
since there is a difference in the second last alaphabet which in Col A it is "e" character and Col B it is "a" character
i want in Column C
Cell C2 to show extracted the difference. either to show the difference character or perhaps if it just indicate what number of characterwithin the text does not match from column B to COlumn A.
would appreciate your feedback