I try to find the right expression to remove some strings in my Google Spreadsheet. I have lot of cells based on this model :
15.01 km2 (5.80 sq mi)
I want to remove all the text from km2 for this result: 15.01.
I've tried LEFT function but it cannot be based on a text. I guess it can be achieved using REGEXEXTRACT.