View Single Post
 
Old 05-21-2017, 11:43 PM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default 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.
Reply With Quote