I have the following in Cell A.

I want to put everything before the left parenthesis into Cell B,
and anything within the parenthesis into Cell C.

Any idea how I make a formula to do this?



Cell A

Abacavir Sulfate (Ziagen)
Abacavir Sulfate and Lamivudine Tablets (Epzicom)
Abacavir Sulfate, Lamivudine, and Zidovudine (Trizivir)
Abarelix (Plenaxis)
Abatacept (Orencia)
Abciximab (ReoPro)
Abelcet (Amphotericin B)
Abilify (Aripiprazole)
Abraxane (Albumin-bound Paclitaxel)
Acamprosate Calcium (Campral)
Acarbose (Precose)
Accolate (Zafirlukast)
Accretropin (Somatropin Injection)
Accupril (Quinapril)
Accutane (Isotretinoin)
Accuzyme (Papain and Urea)
Acebutolol (Sectral)