I've got a cell that contains 4 numbers each separated by a colon and each number consisting of 5 digits. I want to add up all these numbers in the next column without having to create one column for each number and then calculate all four columns. How would you achieve that?
Bookmarks