Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I copy part of each cell in a column?
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? |
#2
|
|||
|
|||
=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? |
#3
|
|||
|
|||
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 , "I should know this!" <I should know 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
same cell from multiple sheets into one column | Excel Discussion (Misc queries) | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
How do you copy a cell formula down a column without displaying n. | Excel Worksheet Functions |