Find the differences between two columns (text)

[Lanjo]

Hi

I am happy to join you here.
I have an excel sheet that contains thousands of rows, and there is two columns that contains similar text, sometimes identical, and sometimes long.
What I need is a way to get the differences of every row of these two columns, maybe in two cells for example: one for the additions from the first column, and the other for the additions from the second one.
It's OK/better if there is a way to highlight the differences instead of these one/two columns of differences.



Notes:
- the differences I am interested in are text addition/deletion, text colors, underlines, bold/normal (the first is essential, the rest are nice if possible).
- I would be great if there is a way to specify a character or more to be ignored.

Thank you

 

[akmatz]

Could you post a few rows of sample data for reference and testing?