Ask Your Question

In calc split 1234567891234 into individual single number cells [closed]

asked 2014-03-12 09:15:15 +0200

caliray gravatar image

I need to select each number of a 13 digit number and place that value into a new cell in calc.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 07:31:23.323253

1 Answer

Sort by » oldest newest most voted

answered 2014-03-12 10:27:57 +0200

m.a.riosv gravatar image

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
(without the curly brackets) in the cell.
if you want the distribution in rows: {=VALUE(MID(A4;ROW(A1:A14);1))}

edit flag offensive delete link more


Works perfectly. Modified it slightly to use a value in column A and start the distribution in column B. Thank you very much.

caliray gravatar imagecaliray ( 2014-03-12 11:07:26 +0200 )edit

Question Tools

1 follower


Asked: 2014-03-12 09:15:15 +0200

Seen: 790 times

Last updated: Mar 12 '14