Add only first numbers in each cell
I have a column with two numbers in each cell like this...
A1: 64 84
A2: 1000 87
A3: 14 999
A4: 32 65
I want to be able to add up only the first numbers in every cell, like this...
64
1000
14
32
...I don't want the second numbers in the cell to be included in the calculation. Is there a way I can do this?
Thanks
Last edited by ewso; 05-22-2017 at 03:39 AM.
|