Hi
I have two cells, one containing first and middle name and another one with
surname. I want to combine the first name and surname into a separate cell,
can you advise how I can just copy the first name and miss out the middle
name please??

Thanks

Caz