Forum Discussion
Sum many numbers in one cell
I have many cells in Word each containing lists of numbers like this: 3,52,708,21,0,13 etc. I want to sum them in Word or, after converting, in Excel. I don't know how to do it in Word or how to conv...
I removed all paragraph breaks in cells in the table, then copy/pasted the table into a new Excel workbook.
I created a small custom function to compute the sum of a comma-delimited list of numbers.
See the attached workbook.