I have information in one column that I would like to pull part of the information over to the adjacent column. Here are some examples of the initial data:
adalimumab (HUMIRA PEN) 40 mg/0.4 mL injection (pen)
Continuous Blood Gluc Transmit (DEXCOM G6 TRANSMITTER) MISC
amphetamine-dextroamphetamine (ADDERALL) 5 mg tablet.
My goal would be to pull everything prior to the parenthesis. in each cell over to the adjacent cell.
adalimumab (HUMIRA PEN) 40 mg/0.4 mL injection (pen)
Continuous Blood Gluc Transmit (DEXCOM G6 TRANSMITTER) MISC
amphetamine-dextroamphetamine (ADDERALL) 5 mg tablet.
My goal would be to pull everything prior to the parenthesis. in each cell over to the adjacent cell.