LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assign numerical value to cell based on selection from drop-down m Tim Excel Discussion (Misc queries) 1 April 6th 10 08:11 PM
HOW TO ASSIGN NUMERICAL VALUES TO LETTERS IN EXCEL teacherpaul Excel Worksheet Functions 5 October 24th 06 02:35 PM
How do I assign numerical values to a letter? Ex: A = 4, B=3, etc Bob1023 Excel Worksheet Functions 1 July 26th 06 02:53 AM
ASSIGN NUMERICAL VALUES FOR LETTERS in EXCEL 2003 legman Excel Worksheet Functions 4 May 14th 06 04:09 AM
Assign numerical values to text codes Bridget Excel Worksheet Functions 3 April 18th 05 11:33 PM


All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"