Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

extract data from cell in google spreadsheet

Posted on 2013-11-12
2
454 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 50

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Cloud file services can fill many different roles for your business. Often, the use of cloud file services begins with employees using consumer products, like Dropbox, to share files with customers and each other. While sync-and-share can be an effe…
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 demonstrate the easy use of Gmail embedding images in your email so the recipient of your email can view them in context.

791 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