"2 hours", in a column in Calc, and I would like to extract the numbers only. I've tried
VALUE(A9), but it doesn't work.
This is an Excel solution but my understanding is that Calc supports most Excel functions.
If your number always appears at the beginning of a text string and is followed by at least one space, then:
will extract the value from such a string in cell A1.