Sum Comma Separated Values in an Entire Column in Just 10 Seconds Working with data where multiple values are stored in a single cell separated by commas? Most people struggle to calculate totals from this kind of messy data. Here is a quick way to handle it in Excel. Use the TEXTSPLIT function to break the values into separate numbers, then wrap it with SUM to calculate the total instantly. Apply it to the entire column and you can clean and analyze your data in seconds. No manual editing, no c