I need to select each number of a 13 digit number and place that value into a new cell in calc.
Having the number/text in cell e.g.
A4: 12345678901234
next matrix formula do the job, distributing in columns: {=VALUE(MID(A4;COLUMN(A1:N1);1))}
as matrix formula you must use Ctrl+Enter not only Enter to introduce the formula
=VALUE(MID(A4;COLUMN(A1:N1);1))
(without the curly brackets) in the cell.
if you want the distribution in rows: {=VALUE(MID(A4;ROW(A1:A14);1))}
Works perfectly. Modified it slightly to use a value in column A and start the distribution in column B. Thank you very much.