Hi,

I have many cells in my worksheet that have text in brackets like this: "some text here [text in brackets to be changed] some additional text here".

I want to create a macro that replaces all text within brackets in my worksheet with the text value in cell C5.

Can someone please tell me how to do this?