Category: Text
Removes spaces from text
TRIM(text)
Category: Text
Returns the leftmost characters from a text value
LEFT(text, [num_chars])
Category: Text
Finds one text value within another (case-sensitive)
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.