Splitting a string of numbers into separate cells: where to even begin?

I am posting this here because I don’t even know if the “VBA/Macros” forum or the “Formulas & Functions” forum would be better (and also to indicate the very basic level at which the answer will need to be for me to understand it).

Basically, I learned recently how to collapse the contents of many cells into one (separated by commas) by going to VBE, inserting a module, copying a code into it, and then back in the spreadsheet typing =ConCat(the cells I want to merge).

I want to reverse that process and split a strong of numbers (without commas- something like 24314231342 but longer) into separate columns. Right now I’m using “text to columns”/fixed width and manually clicking the break line for each digit. But I feel there must be a faster, easier, and less error-prone way.

I did see this thread: http://www.excelforum.com/excel-prog...to-digits.html and tried to understand it. But while I can copy the codes provided, of course, I don’t understand how to use them. I need the kind of step by step directions you would give to the most stupid person possible.

(I’m in Excel 2010, if that helps). I feel like this is hopefully an easy one? I appreciate any help.

With your number in A1
In B1 and copied to the right as far as you want to. Copy down as far as you need to also.
=IFERROR(MID(A1,COLUMNS($A$1:A1),1),"")

If you want them to be considered numbers (for calculations)
=IFERROR(MID(A1,COLUMNS($A$1:A1),1)+0,"")

COLUMNS($A$1:A1) is a way of iterating your value. it counts the number of columns between parenthese (in this case 1) as you drag/copy your formula to the right, it becomes
COLUMNS($A$1:B1) (which equals 2 columns) COLUMNS($A$1:C1) (or 3) and so on.