Fresh Excel Tips

In this exercise, we have a Column that contains 5 digit numbers and we would like to extract them and add them to each other. So, if a cell contains 11223, then result that we would want to be returned is 9 (1+1+2+2+3=9). To do this, we will be using the MID Function to find each digit and then we’ll add them together in our formula. Here is how we’ll achieve this.

How to determine the Sum of the extracted digits

1. In a worksheet, enter a series of four-digit numbers in cells A1:A10
2. Select cells B1:B10 and type the following formula: =MID(A1,1,1)+MID(A1,2,1)+MID(A1,3,1)+MID(A1,4,1).
3. Press CTRL+Enter.

You should now be set! If you found this useful, please leave a comment. Thanks.

1. Use the LEFT, MID, and RIGHT functions to extract date parts
2. How to Separate Cell Values Using the Trim Function in Excel
3. How to use the TEXT function to extract parts of a date in Excel
4. How to Check if a Whole Number can be divided by another number
5. How to Use the FIXED function to round and convert numbers