Compare 2 adjacent cells and any differences, return in a 3rd cell

[Kudrun]

Hi, I hope someone can help me.

I have 2 columns on my spread sheet with lists of addresses in them. These addresses are for the same property (in adjacent cells) but sometimes one address has more info in it than the other.

If the addresses in either are different to their counterpart, I would like to return the difference in a separate column (cell).

Example:

Address 1	Address 2	Difference
1, the street, the town, the county, Postcode	The house name, 1, the street, the town, the county, Postcode	The house name,

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[sgroath]

can you provide some actual samples of the data in the columns showing types of differences?