It's perfect, Purfleet.
Andrew, your code copied the selected cell to the right. There is a formula in col A that joins Col B and C. The macro then does the job of pasting the value in Col A to col B. I have saved your code for future reference.
Thank you all.