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

  • Thread starter I should know this!
  • Start date
I

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

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