Hi,

You can do this by using a helper column next to the address columns, then
hiding the column containing the addresses.

If the first address is in B2, enter into C2:

=IF(B2=B1,"",B2)

This will return a blank value if the address above the one being tested is
the same, or the address if it is not. Drag this formula down the entire
list of addresses then hide the address column.

Is this what you were after?

Ewan.



"Xhawk57" wrote:

I have a list of names and addresses but if two people live at the same
address they are listed separately. Is there a way to combine cells in which
the cell to right is the same.

example: [ John Smith] [123 Maple Ln]
[ Jane Smith] [123 Maple Ln]

becomes: [John Smith [123 Maple Ln]
Jane Smith ]

any help would be greatly apprecitated.