View Single Post
  #1   Report Post  
RememberTwoThings RememberTwoThings is offline
Junior Member
 
Posts: 1
Default Assign numerical value to text in a cell

I am working with a football roster in excel. I have 22 different positions listed on the roster. I would like to assign a number (1-22) to each position so that I can sort the roster in order by position. How can I do this? Thanks.