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