As the set of numbers to sort in different cells?

We would like to make life easier, solving the following problem:
there is a set of numbers and you need to post this whole long code in the appropriate cells as shown on the picture:
all units, and four of them in one cell, two in another. If not present the numbers in the code, for example, no sixes and eights, then a dash. Zeros typed in another cell, not in the matrix.
Really is?
April 19th 20 at 12:32
1 answer
April 19th 20 at 12:34
You either need to create a range of numbers either manually hammer them into the formula.

=ARRAYFORMULA(REGEXREPLACE("190919754153912"; "[^"&{1\4\7;2\5\8;3\6\9}&"]";""))


I prefer the latter.

Suppose there is a range of numbers Satchel


and the cell Zimoveiskaya.


Then it's fair

=ARRAYFORMULA(REGEXREPLACE(Zimoveiskaya; "[^"&Sequal&"]";""))


The examples in the Table
to manually not to drive in the formula numbers, you can make a formula in this part referred to a cell with numbers? - Clementina.Kulas66 commented on April 19th 20 at 12:37
=ARRAYFORMULA(REGEXREPLACE(A1; "[^"&{1\4\7;2\5\8;3\6\9}&"]";""))
- zita commented on April 19th 20 at 12:40
@zita, in that place was a Union of cells and the middle column is not visible because of this... It is somehow solved or want to move the matrix to the other cells? - I would not want to move, because the beauty of the presentation is disturbed. - Clementina.Kulas66 commented on April 19th 20 at 12:43
@Clementina.Kulas66, you need to give examples in Tables, not images. I don't know how to read.

Create a new topic, describe the problem, give an example. - zita commented on April 19th 20 at 12:46
@zita, sorry)

And perhaps even to empty cells appear blank? So visually, I think, are more beautiful. - Clementina.Kulas66 commented on April 19th 20 at 12:49

Find more questions by tags Google Sheets