Solved

extract data from cell in google spreadsheet

Posted on 2013-11-12
2
452 Views
Last Modified: 2015-03-02
lets say i have a text string in a1 in a google spreadsheet

Colonial Early Intervention Center (124)

I'd like b1 to display     124

There could be any number of characters and spaces prior to the first (

Thank you
0
Comment
Question by:colonialiu20
2 Comments
 
LVL 35

Accepted Solution

by:
Kimputer earned 500 total points
ID: 39641706
example only, change all E8 to the cell you need to reference


=right(left(E8,len(E8)-1),len(E8)-find("(",E8)-1)

Open in new window

0
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39641708
Hi,

In XL it would be

=MID(A1,FIND("(",A1)+1,(FIND(")",A1)-1-FIND("(",A1)))

Open in new window


Works even the the closing parenthesis not the last character

Regards
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Google is more than just a search engine. Over the years the company has developed a wide range of online services that are readily available to all users. This article highlights how one can use Google services for simple project management.
If your app took Google’s lash recently, here are the 5 most likely reasons.
This Micro Tutorial  demonstrates whether your site uses one subdomain or multiple subdomains, how to create full URLs from Google Analytics content reports. This procedure is called concatenation and can also be done with the CONCATENTATE function.…
This Micro Tutorial will introduce a Google tool, which is a great way to learn more about dimensions in metrics in Google Analytics, even if you use the interface or the API.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question