Excel: Compare character to character and put results in different column


Hello, I have a need to compare 2 columns and put the result in the third column. The critical part here is to compare letter to letter. so unable to find a logic to do this. Request your help The data is as below:

Column1 Column2 Result
KCVEDPAFLSQBGXZ KCDPLSQXZ VEAFBG


This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of June 06, 2018.


For more resources for Microsoft Excel