Extract value between parentheses

proctk

Well-known Member
Joined
Dec 24, 2004
Messages
839
Hi, I have the following string in Cell A1: 1. First Name (5).

I figured out how to extract the first and last name. I am struggling on how to get the value between the parentheses. The values will range from single-digit to triple-digit.

Forluma to get the name value: =MID(A2,FIND(" ",A2),FIND("(",A2)-1-FIND(" ",A2))
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Finalfight40

Active Member
Joined
Apr 24, 2018
Messages
273
Office Version
365
Platform
Windows
How about:

=MID(A2, SEARCH("(", A2)+1, SEARCH(")",A2)-SEARCH("(", A2)-1)
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,065
Office Version
365
Platform
Windows
One way:
Code:
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"(",REPT(" ",100)),")",REPT(" ",100)),100,100))
 

proctk

Well-known Member
Joined
Dec 24, 2004
Messages
839
Thank you. I was trying to use find. Your solution is perfect.
 

Forum statistics

Threads
1,089,165
Messages
5,406,540
Members
403,096
Latest member
cyclingdad

This Week's Hot Topics

Top