The formula find the space that separates the quantity from the unit, and then extracts the left most part from it.
Removes spaces from text
Returns the leftmost characters from a text value
Finds one text value within another (case-sensitive)
FIND(find_text, within_text, [start_num])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM