Hi,

I am pretty new to excel, and could need your expertise.

I have around 2000 rows, where some of the columns contain "double information". This makes it hard for my pivot table to handle the data..

Some columns contains two numers e.g. "0(0)" or "2.71828(1828.45)" or "-40(40)".. You get the point, two numbers, one within parentheses, in the same cell.

I would like to copy the number within the parentheses into another column, and remove it (including the parentheses) from the original cell.

Example:
Cell A1: "-17(89)" --> Cell A1: "-17" and Cell B1: "89"

Thanks in advance!