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, first.last@company.com.

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?


=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

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

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.