Add only first numbers in each cell

		Microsoft Office Forums > Microsoft Excel > Excel
Add only first numbers in each cell

FAQ

Thread Tools

Display Modes

05-21-2017, 11:43 PM

ewso

Windows 10 Add only first numbers in each cell

Office 2016

Advanced Beginner

Join Date: Nov 2016

Posts: 80

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting numbers within cell	michaelst	Excel	9	04-22-2017 10:51 PM
Difference between 2 numbers in same cell	Neila1982	Excel	1	02-12-2017 01:40 AM
Add Numbers from One or Another Cell	Kilch	Excel	3	01-31-2017 12:55 PM
Search a cell that contains words and numbers and convert the numbers to metric	Carchee	Excel Programming	36	10-08-2014 03:16 PM
adding numbers in same cell	jetdude68	Word Tables	1	07-20-2010 12:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:37 PM.