Changing initials into numbers

  • Thread starter Thread starter Kathie
  • Start date Start date
K

Kathie

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.
 
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.
Click to expand...

see VLOOKUP in Excel help.

Bill
 
Kathie
You have to be more specific. Where are the initials (column, row,
sheet)? Where do you want the numbers placed? HTH Otto
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula 4
Letter = Number 8
Identify part number in list and tag it with characters from another list 4
Count unique values across two columns with multiple conditions 4
Easily mailing list from Data File 3
SUMPRODUCT query 10
Criteria to return maximum value where x = x 3
Datedif doesn't work the same in Excel 2007 1

Back
Top