1

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 at 19:11
0

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

=ArrayFormula(
              "smith_john_"
              &lower(regexextract(ADDRESS(1,ROW(A1:A26),4),"[A-Z]"))&
              "@company.com"
              )

Result :

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.