Good Morning:

I have two cells that contain address information, one is mailing and the
other is street address.

I want to create a formula to compare both cell and to let me know if the
address if the same, if the address is not the same I want to combine them.

I know that to combine a cell I use the formula:
=A2&B2

How do a enter a paragraph mark in between them? meaning how to lines
instead of one long address without breaks?

example:

A2 = 109 Vine Hill & B2 = 3023 Leight Avenue

Result:
109 Vine Hill
3023 Leight Avenue

NOT: 109 Vine Hill 3023 Leight Avenue

But if A2 and B2 are the same, I want to show the address only once.

Example:

A2 = 109 Vine Hill & B2 = 109 Vine Hill

Result:

109 Vine Hill

NOT: 109 Vine Hill 109 Vine Hill

One more variable than I didn't think about, if cell B2 is empty how can I
make sure that only A2 is populated and that I don't have a blank line on the
bottom?

Example:

A2 = 109 Vine Hill & B2 = (Empty)

Result:
109 Vine Hill

NOT:
109 Vine Hill
(Empty Line)



Thank you for your help.

Sincerely,

PaolaAndrea