| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for a formula to create a mnemonic, using two existing col
lets say my excel sheet looks like this:
A B C Last Name First Name Mnemonic Johnston John at the moment the mnemonic column is empty...what I want to do, is create a formula that can take the FIRST letter of the FIRST name, and the first SEVEN letters from the LAST name and insert it into column C. So Excel would take Johnston, John and turn it to Jjohnsto. Can anyone offer me help with this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NEED TO CREATE A CONDITIONAL FORMULA | Excel Worksheet Functions | |||
| help create a formula using the IF command with AND | Excel Discussion (Misc queries) | |||
| How do I create a 26 'tier' IF formula? | Excel Discussion (Misc queries) | |||
| How to create specific formula | Excel Worksheet Functions | |||
| Create formula | Excel Worksheet Functions | |||
Threaded Mode
