View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kanegaro kanegaro is offline
external usenet poster
 
Posts: 1
Default How do I transform a word response to a numeric response?

I have a data base with "Selected" as an indicator of a choice. Instead of
someone choosing a response as a €ś3,€ť €śSelected€ť is in the third column, and
so on. Is there a way to change these €śSelected€ť to their corresponding
numeric values? That is, change all €śSelected €ś in the first column to 1,
and all the €śSelected€ť in column two to 2€¦.. Thank you all for you help.