Formula Required to Get Result of the cell without brackets[SOLVED]

[Khalid NGO]

Hello Everyone,
Greetings from Pakistan...


I need a formula to get result of the cell without brackets "( )"

E.g.

Cell C2 contains: (10 x 20's)
Required formula or custom formatting (which ever is possible)
Result should be like: 10 x 20's

Thanking you in anticipation.
Khalid

 

[Jake Collins]

Dear Khalid

I think this formula should work for you

=IFERROR(MID(C2,FIND("(",C2)+1,FIND(")",C2)-2),C2)

 

[vijay.vizzu]

You can use Find & Replace option to get rid of this..

 

[NARAYANK991]

Hi Khalid ,

Another option :

=TRIM(SUBSTITUTE(SUBSTITUTE(C2,"(",""),")",""))

Narayan

 

[Khalid NGO]

Dear Khalid

I think this formula should work for you

=IFERROR(MID(C2,FIND("(",C2)+1,FIND(")",C2)-2),C2)

Thanks Collins,
Its working fine...
God bless you.

 

[Khalid NGO]

Hi Khalid ,

Another option :

=TRIM(SUBSTITUTE(SUBSTITUTE(C2,"(",""),")",""))

Narayan

Wow...
Thanks Sir Narayan,
Its a very cool one.
God bless you...

 

[Khalid NGO]

You can use Find & Replace option to get rid of this..

Thanks Vijay,

Actually i have a list with more than 150 rows.
Find & Replace will be okay if there is a single entry.

Thanks for your efforts.
God bless you.

 

[Hui]

As Vijay suggested you can use Find/Replace to do what you want
Select the whole set of data
Do a Find/Replace twice
Once for ( with a blank
Once for ) with a blank

 

[Khalid NGO]

As Vijay suggested you can use Find/Replace to do what you want
Select the whole set of data
Do a Find/Replace twice
Once for ( with a blank
Once for ) with a blank

Yes its interesting trick Sir Hui, I have noted for future bugs...
Actually I don't want to replace brackets (as i need them somewhere in my sheet)
I have used a Vlookup function to get (10 x 20's) from a list.


I have managed my data with Narayan and Collins suggestions.
Many thanks for your idea.