Combine cells and add characters

[stevembe]

Thanks for taking the time to read. I have a list of surnames in Column A and first names in column B and I need to combine the two into one cell which I can easily do by joining strings. However I also need the format changed with characters adding so:

from this: Smith John

to his: Smith, John (UK)

Most grateful for any ideas.

 

[mumps]

Are you using formulas to combine the cells? How do you decide what characters to add for each name?

 

[stevembe]

Using the "&", not formula. The adding of a , followed by space and (UK) at the end of the name will be the same characters for every record.

 

[Fluff]

How about
=A2&", "&B2&" (UK)"

 

[mumps]

Place this formula in C1 and copy it down: =A1&", "&B1&" (UK)"

 

[stevembe]

Both, works perfectly, thank you so much for your advice, very much appreciated.

 

[Fluff]

Glad we could help & thanks for the feedback