Thread: Is there a function or format to remove 'oz' from '12oz' in Excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Skip Skip is offline
external usenet poster
  
Posts: 8
Default Is there a function or format to remove 'oz' from '12oz' in Excel?
I'm trying to see if there is a way to take another user's input of "12oz",
say in cell A1, and convert it to the numeric value of just '12' in another
cell, say B1, so I can use the numeric value for calculations?
Reply With QuoteReply With Quote