Extract a specific portion of text as new cell value

[Craig860]

I have a question for the excel masters. (genuflect)

If I have a list of values in a list that contain some unwanted text. For
example:
(jblow)
(mjane)
(jqpublic)

Basically I want a new cell that has the mjane or the jblow without the
parenthesis.
I can't figure out a function that will search for the parenthesis.

 

[Gator]

Highlight the column, go to Edit, select Replace, First, put in ( in 'Find
what' and select Replace all. Do again for ).

 

[Craig860]

This will be a lesson to me in being more specific.
Cell a1 = Jane, Mary (mjane)
i'd like b1 to = mjane

 

[Gator]

Column B - =FIND(")",A1,1)
Column C - =FIND("(",A1,1)
Column D - =MID(A1,D1+1,(C1-D1-1))
Highlight Column D and Copy and Past Special / Values. Then you can delete
Column B and C

 

[Craig860]

I'm getting a circular reference error when I entered the column D formula

 

[Gator]

Sorry...Column D should be - =MID(A1,C1+1,((B1-C1)-1))

 

[Bob I]

b1 contains

=MID(A1,FIND("(",A1)+1,(FIND(")",A1)-FIND("(",A1)-1))