Combining names with an & inbetween

[naomiisaacs]

Dear Forum,

I need to combine:
Firstname 1, Surname 1 & Firstname 2, Surname 2 so that they appear in one call with an ampersand and spaces inbetween. I know the formula:
<table width="267" border="0" cellpadding="0" cellspacing="0"><col width="267"><tr height="18"> <td class="xl26" style="height: 13.2pt; width: 200pt;" width="267" height="18">=(O2&", "&N2)&(Q2&", "&P2)</td> </tr></table>But that returns the two names without an and or spaces:

Jo, SmithPeter, Clarke

I need it to look like this:
Jo, Smith & Peter, Clarke

Thank you for your help. And I love your videos, I have taught myself a lot.

 

[Richard Schollar]

=o2 & ", " & n2 & " & " & q2 & ", " & p2

 

[njimack]

=o2&" "&n2&"& "&q2&", "&p2

 

[naomiisaacs]

Genius!
Thank you for your help!

 

[crook_101]

Hi,

Welcome to the Board.

Slight ammend to your formula - i think these are the columns that you are using

Excel Workbook
	N	O	P	Q	R
1	Surname 1	Firstname 1	Surname 2	Firstname 1	Result
2	Smith	Jo	Clarke	Peter	Jo, Smith & Peter, Clarke
Sheet1

Cheers,
Ian

 

[naomiisaacs]

Thanks again. Spreadsheet reads better now