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

=if(A2<B2,A2&char(10)&B2,A2)
be sure text wrapping is enabled
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"PaolaAndrea" wrote:

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

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

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



PaolaAndrea wrote:

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

--

Dave Peterson

You need to turn on wrap text under formatcellsalignment and make sure the
row height fits 2 lines

=A1&CHAR(10)&B1



--


Regards,


Peo Sjoblom


"PaolaAndrea" wrote in message
...
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

=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" wrote:

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

Thank you, that worked great.

"KC Rippstein" wrote:

=if(A2<B2,A2&char(10)&B2,A2)
be sure text wrapping is enabled
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"PaolaAndrea" wrote:

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