I'm creating a database of individuals in a company in Google Sheets. I'm collecting the persons email address, first name, last name all in different columns. The email addresses for all these people always use the same syntax, [email protected].

Is it possible to create a function in Google Sheets that will auto generate the email address based on data entered in the "First name" and "Last name" columns?

1 Answer 1


=CONCATENATE(A1,".",B1,"@company.com") will do exactly what you want:

sheets email concatenate

It may not be the prettiest answer, but you can also combine a few concat() functions together to get =CONCAT(CONCAT(CONCAT(A1,"."),B1),"@company.com") to do this:

sheets email concat

  • Just click the little blue square at the bottom right of that field and drag down. Commented Aug 14, 2015 at 15:15
  • "=CONCATENATE(A1,".",B1,"@company.com")" works great, thank you.
    – mmt
    Commented Aug 14, 2015 at 15:16
  • Will do, just as soon as I have the reputation. Your response was a big help!
    – mmt
    Commented Aug 14, 2015 at 16:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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