It is necessary to display only numbers from the column, but when outputting, it skips the first line, why?

S

S

sheet2019-03-27 14:30:31

Google Sheets

sheet, 2019-03-27 14:30:31

It is necessary to display only numbers from the column, but when outputting, it skips the first line, why?

example that in the column - [He] 2s2 2p6 that we get 2226 as I did - =VALUE(REGEXREPLACE(q!L3:L,"\D+", ""))
Problem: there are 10 elements in the column when formula 1 is executed for some reason, then 9 elements are processed and at the end of 10 the element displays 0.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

C

cosmo34522022-02-16 13:47:21

How to make a checkout in google spreadsheet? 1Reply

V

Vyacheslav Zinchenko2018-12-25 02:19:42

Is it possible to make an Importrange from a table that has "View Only" access? 0Reply

F

felior2022-02-22 21:57:16

How not to populate the "Email" field from Google Forms to Google Sheets? 1Reply

C

chakaponi2019-01-05 18:07:49

How to get a non-empty value when accessing a merged cell? 0Reply

I

Illia2019-01-08 16:04:53

Is it possible to sort by index into different sheets? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question