Please enable JavaScript to view the comments powered by Disqus.


TRIM(...LEFT(...A10,FIND(..." ",A10)))

How to extract number from a physical quantity with measuring units. 

The formula find the space that separates the quantity from the unit, and then extracts the left most part from it.


Used Functions

Category: Text

Removes spaces from text

Syntax

TRIM(text)

Category: Text

Returns the leftmost characters from a text value

Syntax

LEFT(text, [num_chars])

Category: Text

Finds one text value within another (case-sensitive)

Syntax

FIND(find_text, within_text, [start_num])

Lets chat on this