Changing initials into numbers

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

Bill Sharpe

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
 
O

Otto Moehrbach

Kathie
You have to be more specific. Where are the initials (column, row,
sheet)? Where do you want the numbers placed? HTH Otto
 
Top