[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 492
  • Last Modified:

extract data from cell in google spreadsheet

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
colonialiu20
Asked:
colonialiu20
1 Solution
 
KimputerCommented:
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
 
Rgonzo1971Commented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now