I have "1 hour"
, "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.
Cell value string to Int in OpenOffice Calc
openoffice-calcworksheet-function
openoffice-calcworksheet-function
I have "1 hour"
, "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.
Best Answer
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.