Changing Contents of a cell.
Ok, So i have a few columns of data with about 1600 rows or so per column
The data in the rows looks like what is shown below. The numbers in the
rows are stored as text. Here is what i need to do, I need the first number
ONLY, and not the percentage. So basically i need to turn every cell into
the number that appears first in every cell, and then delete the parentheses
and percentages.
Anyone have any easy way to do this?
3 (8%)
4 (12%)
0 (0%)
8 (15%)
0 (0%)
0 (0%)
0 (0%)
0 (0%)
0 (0%)
7 (5%)
6 (3%)
10 (4%)
|