Purfleet, internet is still down so I can't send the code that I initially got from macro recording.
I need to join cells from col B and C through the concatenate function in H1. After the join, I copy the result back to say, B2 by paste special value. Afterwhich I delete C2. I am hoping that a macro will do the job of pasting the result of H1 to the present cell reference in Col B and delete the cell to its right in column C.
If I change the cell references in H1 to B7 and C7, then run the macro, the value should in H1 should be pasted in B7, and C7 deleted.