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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for a formula to create a mnemonic, using two existing col
=left(b1,1)&left(a1,7)
"Mnemonic Man" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for a formula to create a mnemonic, using two existing
Perfect! Thank you so much, I just got the mnemonic for 950+ names in about
30 seconds with your help! "Toppers" wrote: =left(b1,1)&left(a1,7) "Mnemonic Man" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for a formula to create a mnemonic, using two existing
No problem .... and thank you for the feedback.
"Mnemonic Man" wrote: Perfect! Thank you so much, I just got the mnemonic for 950+ names in about 30 seconds with your help! "Toppers" wrote: =left(b1,1)&left(a1,7) "Mnemonic Man" wrote: 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? |
Reply |
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 |