Guys,

I have a sheet , contain only 1 column consists of 1000 records. Some part of data includes data in braces.
I want to remove the data with in the braces and braces too. Is there any function for this?

Eg.

Input :- Hi How are you(JAGAN)?

Output :- Hi How are YOU?

Please help me in this.

Thanks in Advance.
@Jagan