Solved

extract data from cell in google spreadsheet

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Multiple vlans on a switchport 9 70
Google/Gmail known issues webpage 2 86
Excel 2010 - Select category per Max values 5 45
ost file to pst 10 107
Learn new improvements released by Google for Google Calendar. Noted in this article are simple tips and tricks that can make your everyday use of Google Calendar better.
You can provide a virtual interface for remote stakeholders in a SWOT analysis through a Google Drawing template. By making real time viewing and collaboration possible, your team can build a stronger product.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This Micro Tutorial demonstrates in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now