• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

Khalid NGO

Excel Ninja
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
 

Attachments

  • Formula required to remove brackets.PNG
    Formula required to remove brackets.PNG
    21.7 KB · Views: 14
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
 
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.
 
Back
Top