Solved

extract data from cell in google spreadsheet

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel Score Formula 5 75
Excel sheet question 12 55
CUT & PASTE VALUES IN EXCEL USING MACRO -- SPECIFIC CELLS 27 89
Converting time 4 35
I'm Dumb-phoned(ed) Last week, I noticed this message when adding events to my Google Calendar: On June 27th (2015), Google is removing SMS as a notification option for Google Calendar events.  Their assumption is that enough people have smart p…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrates in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
By using UNIQUE function in Google Sheets, you can get around removing duplicates like in Microsoft Excel.

685 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