I am trying to write a formula to add the number values in a cell. For example If I populate cell (A1) with the number 12345 I would like to see the sum of those numbers in cell (B1). I can pull this off using LEN and MID.
However, if column A is populated with number values of varying lengths my formula breaks. I DO NOT want to do this using VBA. Any ideas?
However, if column A is populated with number values of varying lengths my formula breaks. I DO NOT want to do this using VBA. Any ideas?