Hi all, I am xoxo and new to this forum.
Would like help on how to calculate numbers within a cell. Say, I have these numbers in A1: 01-02-03-04-05 and I want A2 to give me the sum of all the numbers in A1 without the dash. Is it possible?
Thank you very much!
xoxo
Would like help on how to calculate numbers within a cell. Say, I have these numbers in A1: 01-02-03-04-05 and I want A2 to give me the sum of all the numbers in A1 without the dash. Is it possible?
Thank you very much!
xoxo