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.
|