TRIM(...)
How to extract number from a physical quantity with measuring units.
Used Functions
Category: Text
Removes spaces from text
Syntax
TRIM(text)
Practice TRIM Formula at Sheetzoom
TRIM formula at Microsoft helpCategory: 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])
1
The formula find the space that separates the quantity from the unit, and then extracts the left most part from it.