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:
5e999abf06648904734083.png
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
Solution
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}&"]";""))


5e99a4c0baf62310772297.png

I prefer the latter.

Suppose there is a range of numbers Satchel

5e99a2a035e5f988302929.png

and the cell Zimoveiskaya.

5e99a3082461b539823836.png

Then it's fair

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


5e99a31fc0976747925730.png

The examples in the Table https://docs.google.com/spreadsheets/d/19bQjuZpRaE...
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)
https://docs.google.com/spreadsheets/d/19bQjuZpRaE...

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