Welcome to our tutorial on how to SUM Multiple Numbers Within a Single Cell in Excel.
🎓 LEARN MORE in my Excel tutorials: excelkid.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love.
Chapters:
00:00 Intro
00:04 How to SUM Multiple Numbers Within a Single Cell
Type TEXTSPLIT. The first argument is the cell you want to split.
A great feature of the function is that we can create an array with it, which allows us to handle multiple delimiters. Let's create an array! In this cell, we can identify three types of delimiters. The first is the comma, the second is the double comma, and the third is a comma followed by a space character.
We use these delimiters as the second argument in the TEXTSPLIT function.
Each pattern is separated by a comma. Press Enter.
Now we have an array that contains separated text values. To convert text values to numeric values, I'm using the double negative method. The last step is to add the sum function to summarize the array. If you have various delimiters, you can easily append the array using additional delimiters.
#exceltips #excel #exceltutorial