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

"I should know this!" <I should know wrote
in message ...
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?