3 ms·
In LibreOffice, you can just use the formula =IF(ISNUMBER(A1), A1, NUMBERVALUE(REGEX(A1, "[^0-9]", "", "g"))) to get the equivalent of the column C to pas
by Karellen 4y ago
In LibreOffice, you can just use the formula
=IF(ISNUMBER(A1), A1, NUMBERVALUE(REGEX(A1, "[^0-9]", "", "g")))
to get the equivalent of the column C to paste special from.
No need to invoke any other languages or APIs. Just use the native cell functions.
- yosito 4y agoNice! Easy enough. Still, if I didn't know the formula, running a JavaScript macro is often a quicker option for me as a JavaScript developer.
- Karellen 4y agoI didn't know it either. And I wouldn't call myself a LibreOffice power user. But I still don't think it was very hard to put that together in 5 minutes using informed trial-and-error, LibreOffice's built-in autocomplete, and one bit of DDG/StackOverflow to find the name of the `NUMBERVALUE()` function.