# extract (parse?) text string [closed]

I have a number (04121997) as text. The solution I'm looking for could be used for a number, whichever is best because I don't know how to do either one.

I need to extract (parse?), each number and put it into its' own cell as the ultimate goal is to sum the numbers in the string. I tried `=LEFT(A2;1)`

which gets the left most number, but what do I add to get the 2nd, 3rd, etc. numbers put into cells by themselves? I don't know how to set up the offset and the related questions were very complex FIND and SEARCH formulas that seem way too complex for such a simple problem.

Also, do I need to be concerned about the length of the string? It will always be 8 digits as these are text or digits representing dates and I will always include zeros in the string. That's why I'm writing them as text so CALC doesn't truncate the number when it sees a leading zero.

Thanks for the help.