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

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