Hi,
For ex: In a cell, lets say the value is 'Microsoft'. i want to create a
button or a macro such that, if i click that it should insert ')' before &
after that word.

How to do it?

Rgds,
Venkatesh