Hi guys,

First post here so please be gentle!

I have a sheet that contains users names and their country code, for example C1 is John, D1 is Smith and E1 is UK

What I need is for the value in E1 to be pasted at the end of D1 with a hyphen i.e. "Smith - UK"

Is this at all possible? If so can someone point me in the right direction as all of the things I try seem to want to replace my original text in D1

Any help you can give will be greatly appreciated.

Thanks
Darren