In Open Office Spreadsheet I have cells with strings like "123kg" "3,45m" "0,5g" "345apples" etc.
Which is the function that can parse the numeric prefix on these numbers? So I get "123" "3,45" "0,5" "345".
The VALUE function expects a 100% correct numeric value without postfixes. It cannot parse the prefix only.