A
A
Alina Shah2020-04-18 19:52:29
Google Sheets
Alina Shah, 2020-04-18 19:52:29

How to make a blank cell have a dash?

Using the formula ARRAYFORMULA from a set of numbers (long code) 30091968369303, units are carried into different cells into one cell, all two into another, etc.
Those numbers that are not present in the long code would like to see a dash (-).
It looks more visual.
Table at the link:
https://docs.google.com/spreadsheets/d/1vqKnsN_8qQ...
I would be grateful if there is a solution :)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-04-18
@Shah_Alina

Just add a condition to the formula

=ARRAYFORMULA(
  IF(
    REGEXREPLACE(Цифровое_представление; "[^"&Сетка_чисел&"]";"")="";"-";
    REGEXREPLACE(Цифровое_представление; "[^"&Сетка_чисел&"]";"")
  )
)

5e9b68e045bc9627473378.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question