noushie

Add an 'and' between 2 names

Discussion created by noushie on Feb 16, 2012
Latest reply on Feb 23, 2012 by comment

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?

Outcomes