Need help on Excel, need to copy text from one cell into the middle of text in another!

Hi Guys,

Last time I used this site it was absolutely fantastic, I've been racking my brains out and I wouldn't ask unless I really needed the help.

I have certain text in one column, in this case column B, and I need to paste it into the text to the left of the cell in column A, so B1 must go into A1 and replace the word key's in this instance.

Practically I will be using the marco or solution in the same way, with varying text and length, each cell will only state the word, in this instance Key's, once, in that cell, for example the word Key's in cell A1.

I appreciate any help I can be given, my VB & macro skills are not what they once were so thank you in advance to whoever helps.

Just realised the Substitute function is way better to use, managed to figure it out and now it's working, thank you for taking the time to view and consider, I think I was being a dumb dummy, if there is a better way other than substitute function then please let me know, thanks again excel forum!