Selective concantenation

[MIZDBLACK]

Hi there,
I wonder if anybody can help me with a formula for this?
If the address in cells B2 and B3 are the same, then I need to concantenate cells A2 and A3 so that the householders names are joined together.

Thanks

 

[Peter_SSs]

Like this?

=IF(B2=B3,A2&" "&A3,"")

 

[MIZDBLACK]

Hi Peter,

That works - thank you so much. However, I think I will need the word 'and' between the two names, do you know how to do this at all?

 

[Richard Schollar]

Minor adj:

=IF(B2=B3,A2&" and "&A3,"")

 

[MIZDBLACK]

That is perfect. Thanks very much - you're a star