How to Remove the data in Braces in an Excel Sheet

[jaganr10]

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

[benishiryo]

hi Jagan, welcome to the forum. maybe:
=REPLACE(A1,FIND("(",A1),FIND(")",A1),"")

or if some data dont have brackets, then:
=IF(ISNUMBER(FIND("(",A1)),REPLACE(A1,FIND("(",A1),FIND(")",A1),""),A1)

[jaganr10]

Hi benishiry,

Thanks for your reply, I appreciate it.

But the function you've provided is not working Exactly what i want.

Eg:- Aviemore Drive (Highland Park) Countdown Supermarket(SR13.00 Pilot)

It's giving the output as :- Aviemore Drive rmarket(SR13.00 Pilot)

I wanted the output is as:- Aviemore Drive Countdown Supermarket

[:) Sixthsense :)]

In A1 cell
Aviemore Drive (Highland Park) Countdown Supermarket(SR13.00 Pilot)

Or try this...
In B1 cell

Please Login or Register  to view this content.

[jaganr10]

Hi Sixthsense ,

Thank you very much It's working fine, but if the data contains two braces then only it's functioning properly else it's not..

Eg: Watergardens (Taylors Lakes) Safeway Supermarket,

for this data, it's not giving the proper results..

For Sample Take the below Data:

Mountain View (Mt Gravatt) Woolworths Supermarket
Murray Street (Perth City) Woolworths Supermarket
Allenstown Hotel Dan Murphys (Rockhampton) (ALH)
Campbelltown (Marketfair) Woolworths Supermarket
Launceston Danks - Beck's HoME Timber & Hardware
Little Mountain BWS (Pelican Waters Hotel)ALH)

[VKS]

After your last update i think my file should be deleted