I have a long list of text values like "8lbs 9oz" that I need to compare to a standard weight. Seems to me the easiest method would be to convert pounds to ounces to express the whole value in ounces and then do the calculation, but I'm getting tripped up in how to convert to ounces. I've attached a workbook with the correct answers, need help in figuring out a formula to get those correct answers. Any help would be appreciated.
Bookmarks