Looking for a formula to create a mnemonic, using two existing col

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Perfect! Thank you so much, I just got the mnemonic for 950+ names in about
30 seconds with your help!
 
No problem .... and thank you for the feedback.

Mnemonic Man said:
Perfect! Thank you so much, I just got the mnemonic for 950+ names in about
30 seconds with your help!
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Formula 4
matching full name to 'two column' name using sumproduct 9
Lookup a name if cell value first letter is in a range 1
Formula to choose from the last column of a given row 1
Lookup based on two fields without merging? 5
Excel Excel - Two Database Formula extraction? 3
Use Len and Left to make name 3 letters 2
Format Name 6

Back
Top