How do I copy part of each cell in a column?

[Guest]

I have a column of data - ie: (1APB-0101) BFP Motor Valve
I want to copy the information in ( ) to another column.
How can I do this?

 

[Bob Umlas]

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
and fill down

 

[JE McGimpsey]

One way:

If all the items inside parens in the column are 9 characters long:

=MID(A1,2,9)

if the items inside parens vary in length (but are at the beginning):

=MID(A1,2,FIND(")",A1)-2)

if the items in parens may not be at the beginning:

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

Where 255 is just a number larger than any potential string inside
parens.