Function problem

[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

 

[JohnI in Brisbane]

Danielle,

Assuming a name is in A2, try this

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

regards,

JohnI

 

[Don Guillett]

use find to find the "(" and to find the ")"
within the mid function

 

[Daniel.M]

Hi Danielle,

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

Regards,

Daniel M.

 

[Guest]

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