Combining Cell Contents

[PaolaAndrea]

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


Thank you for your help.

Sincerely,

PaolaAndrea

 

[KC Rippstein hotmail com>]

=if(A2<>B2,A2&char(10)&B2,A2)
be sure text wrapping is enabled

 

[Dave Peterson]

=a2&if(a2=b2,"",char(10)&b2)

Remember to change the format to wrap text.
(Format|Cells|alignment tab in xl2003)

 

[Peo Sjoblom]

You need to turn on wrap text under format>cells>alignment and make sure the
row height fits 2 lines

=A1&CHAR(10)&B1



--


Regards,


Peo Sjoblom

 

[BoniM]

=IF(B4=C4,B4,B4&CHAR(10)&C4)
The cell containing the function must have wrap text turned on, or you will
still see it on one row, separated with [?].

 

[PaolaAndrea]

Thank you, that worked great.

=if(A2<>B2,A2&char(10)&B2,A2)
be sure text wrapping is enabled