Home |
Search |
Today's Posts |
#1
|
|||
|
|||
splitting text within parenthese into new column
I need to split out the text with the parentheses into a seperate column
i.e A1 B1 C1 1 AA, CC, (BB) AA, CC BB 2 AA, (BB), CC AA, CC BB 3 4 etc. etc. etc. Thank You in advance John |
#2
|
|||
|
|||
To split out the (BB) in the example you give, use this equation:
=MID(A1,SEARCH("(",A1)+1,SEARCH(")",A1)-SEARCH("(",A1)-1) You'll have to play around with something like this and possibly concatenate the results if the (BB) is in the middle of the string. You may also need to use the LENGTH() function to ensure that you have everything. "John" wrote: I need to split out the text with the parentheses into a seperate column i.e A1 B1 C1 1 AA, CC, (BB) AA, CC BB 2 AA, (BB), CC AA, CC BB 3 4 etc. etc. etc. Thank You in advance John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Changing column size w/o losing text | New Users to Excel | |||
Sort or Filter option? | Excel Worksheet Functions | |||
How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions |