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:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/7UbAXBhHXW4;context-place=forum/docs
TRIM(MID(SUBSTITUTE) - Return value in between two strings
TRIM(MID(SUBSTITUTE) - Return value in between two strings
Hi all,
I want to return the value in-between the parentheses in a cell. For example:
So output would be:
B1: Grow Learning
B2: Jeanswest
B3: Uphill
B4: Skilled People
B5: Easy Dreams
Your help is much appreciated!
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!
No comments:
Post a Comment