Extract value between parentheses

[proctk]

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))

 

[Finalfight40]

How about:

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

 

[Joe4]

One way:

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"(",REPT(" ",100)),")",REPT(" ",100)),100,100))

 

[proctk]

Thank you. I was trying to use find. Your solution is perfect.