Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Extracting Data Within Parentheses

1. I agreed to these rules
Join Date
22nd August 2006
Posts
7

## Extracting Data Within Parentheses

Hello,

I need to come up with a formula that will pull the data located within parentheses. Here is an example below:

CHRISTINE DALEY (497998)
LINDA DALEY (503094)
STEPHAN DANIEL (100360949)

Thanks!

Excel Video Tutorials / Excel Dashboards Reports

2. Established Member
Join Date
10th August 2005
Posts
844

## Re: Extracting Data Within Parentheses

Assuming your example data is in cell A1:
VB:
```=MID(A1,FIND("(", A1)+1,LEN(A1)-FIND("(", A1)-1)

```

Excel Video Tutorials / Excel Dashboards Reports

3. I agreed to these rules
Join Date
22nd August 2006
Posts
7

## Re: Extracting Data Within Parentheses

That worked perfectly! Thank you!

Excel Video Tutorials / Excel Dashboards Reports

4. Established Member
Join Date
10th August 2005
Posts
844

## Re: Extracting Data Within Parentheses

Glad to help and welcome to OzGrid

Excel Video Tutorials / Excel Dashboards Reports

5. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,648

## Re: Extracting Data Within Parentheses

=mid(a1,find("(",a1)+1,sum(find({"(",")"},a1)*{-1,1})-1)

Hth

6. ## Re: Extracting Data Within Parentheses

Another way, which will return a true number, not text
=--SUBSTITUTE(MID(REPLACE(A1,FIND(")",A1)+1,256,""),FIND("(",A1)+1,256),")","")
Last edited by Dave Hawley; September 15th, 2006 at 17:36.

7. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,648

## Re: Extracting Data Within Parentheses

Both Dave's and ShosMeister's formula will fail if there are anything after the 2nd parentheses.

8. ## Re: Extracting Data Within Parentheses

Not anymore

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