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?

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?

asked April 19th 20 at 12:32

1 answer

answered on

Solution

You either need to create a range of numbers either manually hammer them into the formula.

I prefer the latter.

Suppose there is a range of numbers

and the cell

Then it's fair

The examples in the Table https://docs.google.com/spreadsheets/d/19bQjuZpRaE...

`=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 https://docs.google.com/spreadsheets/d/19bQjuZpRaE...

Find more questions by tags Google Sheets

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

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