Need from the column to display only numbers, but the output skips the first line, why?

an example of what the column is [He] 2s2 2p6 receive 2226 as I did - =VALUE(REGEXREPLACE(q!L3:L,"\D+", ""))
Problem: the column has 10 elements, when you run a formula 1 somehow skipped then 9 elements are processed and at the end of 10 item displays 0.
March 19th 20 at 08:50
0 answer

Find more questions by tags Google Sheets