| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement to input initials | Excel Discussion (Misc queries) | |||
| In a workbook, how do I not have initials split and wrapped? | Excel Discussion (Misc queries) | |||
| Need Period After Initials | Excel Worksheet Functions | |||
| Create initials from Full name | Excel Discussion (Misc queries) | |||
| How to pluck out initials of a 2 or 3 word name | Excel Worksheet Functions | |||
Linear Mode
