The formula find the space that separates the quantity from the unit, and then extracts the left most part from it.
Get anything to the left of first space or underscore
Performing VLOOKUP() from multiple sheets.
How to use VLOOKUP() to lookup value from another worksheet.
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