Thread: Can I assign a numeric value to words in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
  
Posts: 138
Default Can I assign a numeric value to words in Excel?
Use a look-up table and the VLOOKUP function but don't forget to use
the False option if you enter your data into the table in numerical
rather than alphabetical order.

Reply With QuoteReply With Quote