Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Calculate Number in Brackets/Parenthesis

1. I agreed to these rules
Join Date
28th July 2006
Posts
3

## Calculate Number in Brackets/Parenthesis

Is it possible to extract a number in brackets specifically from a cell, then increase it by 15%, and return the result back into the brackets.

For example the cell consists the following:
Mary (78)

so the aim is to get the 78 out for calculation, then change the content of the cell with the new result.

Or is there a macros that can be created for this?

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: Editing a specific value in a cell

One way

=--SUBSTITUTE(MID(A1,FIND("(",A1)+1,256),")","")+(SUBSTITUTE(MID(A1,FIND("(",A1)+1,256),")","")*15%)

Or use Edit Replace and replace the ( and ) with nothing. Then copy any cell housing .15 then select the resulting numbers (after Edit>Replace) and go to Edit>Paste Special - Value - Multiply - OK

3. ## Re: Editing a specific value in a cell

BTW, if the numbers is placed back into brackets it will again become text. So use a Custom Number Format like "("0.00")"

4. I agreed to these rules
Join Date
28th July 2006
Posts
3

## Re: Editing a specific value in a cell

Thx real much.

Is it possible to change a cell from Mary (78) to Mary (89.7)?
Doing the same operation, but at the end keeping the text format?

i'm a total excel idiot...
Last edited by eowplum; July 28th, 2006 at 15:23.

Excel Video Tutorials / Excel Dashboards Reports

5. ## Re: Editing a specific value in a cell

How about Edit>Replace and replace ) with .7)

6. I agreed to these rules
Join Date
28th July 2006
Posts
3

## Re: Calculate Number in Brackets/Parenthesis

Thx real much, I understand everything now!

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno