I have joined the primary and secondary contact names. For example, if the primary contacts is called John Smith and his wife Anna Smith, I have joined these into one field and get John Smith Anna Smith. I have 2 questions:
How do I add an 'and' between the two contacts? eg. so I get John Smith and Anna Smith.
Also, how do I exclude the surname from appearing twice, eg, reduce it to John and Anna Smith?