Thread: Changing initials into numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill Sharpe Bill Sharpe is offline
external usenet poster
  
Posts: 348
Default Changing initials into numbers
On 2/3/2010 9:26 AM, Kathie wrote:
I have data that I download into Excel and initials are used for different
people. I need to give those initials a number in excel for example MJ = 01,
HS = 02..etc. Thank you.

see VLOOKUP in Excel help.

Bill
Reply With QuoteReply With Quote