For example I have an email for John Smith and am trying to find out his appropriate middle initial. The email format is smith_john_(middle initial)@company.com but I cannot get the email to auto populate using the "little blue box and drag" method.

Is there a formula I could use?

  • question is not clear, please share a copy of your sheet with example of desired result – user0 Jul 26 '19 at 19:11

Here's a way to do it with the 26 letters of the alphabet :


Result :

enter image description here

Your Answer

