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

[I should know this!]

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

"I should know this!" <I should know [email protected]> wrote
in message news:[email protected]...
> 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?
>

[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.

In article <[email protected]>,
"I should know this!" <I should know [email protected]>
wrote:

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