Google-sheets – How to auto populate potential email combinations in Google Sheets

emailgoogle sheets

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?

Best Answer

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

Related Topic