splitting text within parenthese into new column

[Guest]

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

 

[Guest]

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.