Hoping someone can help with this - I have varying values of differing lengths in individual cells that I need to sum eg -
A1 contains the value 198262456. I need to sum each number in that cell for a total of 43. I have been using the Mid function - =MID(A1,1,1)+MID(A1,2,1)+MID(A1,3,1)+ etc etc but the problem that I run into is that the cell character lengths can vary between 8 to 20, & I get #Value! errors when the MID formulas exceed the characters.
Any solutions?
A1 contains the value 198262456. I need to sum each number in that cell for a total of 43. I have been using the Mid function - =MID(A1,1,1)+MID(A1,2,1)+MID(A1,3,1)+ etc etc but the problem that I run into is that the cell character lengths can vary between 8 to 20, & I get #Value! errors when the MID formulas exceed the characters.
Any solutions?