Wednesday, May 31, 2017

yogi_Pull Into Another Column Text Left Of Material Within Parentheses

Google Spreadsheet   Post  #2172
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-31-2017
question by DaveLLL:
Hi all,

I want to return the value in-between the parentheses in a cell. For example:

A1: Nicky Ring (Grow Learning)
A2: Chloe Fulman (Jeanswest)
A3: Corey Brewer (Uphill)
A4: Charles Post (Skilled People)
A5: David Chow (Easy Dreams)
 
So output would be:
B1: Grow Learning
B2: Jeanswest 
B3: Uphill
B4: Skilled People
B5: Easy Dreams

Your help is much appreciated!