ExcelBanter - Changing initials into numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Changing initials into numbers (https://www.excelbanter.com/excel-worksheet-functions/255239-changing-initials-into-numbers.html)

kathie

Changing initials into numbers

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.

Bill Sharpe

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

Otto Moehrbach[_2_]

Changing initials into numbers

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

"Kathie" wrote in message
...
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.

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