Function problem

  • Thread starter Thread starter Danielle
  • Start date Start date
D

Danielle

Hi, I am trying to find a way to take all info in ( ) and
make a new column. I can't use right or left function
because the text in the ( ) varies. Example:

Finance Officer (Matt Jones)

I need the Matt Jones in a new column.

Any suggestions?

Thanks
 
Danielle,

Assuming a name is in A2, try this

=MID($A2,FIND("(",$A2)+1,FIND(")",$A2)-FIND("(",$A2)-1)

regards,

JohnI
 
Hi Danielle,

With your name in A1:
=MID(A1,FIND("(",A1&"(")+1,FIND(")",A1&"()")-FIND("(",A1&"(")-1)

Regards,

Daniel M.
 
Its fairly easy using the arcane FIND function with MID
The formula below has your text in C5.

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


email me if you want an explanation on how it works.

Steve H
 
Back
Top