Thread: Converting a text word or text string to a number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Converting a text word or text string to a number
With a word in A1:

=LOOKUP(A1,{"none","one","two","three";0,1,2,3})


--
Gary''s Student - gsnu200823


"Tom" wrote:

How can I convert a text word (i.e. None) to a number (i.e 0)?
Reply With QuoteReply With Quote