1

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?

Improve this question

1 Answer 1

Reset to default
3

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

Your Answer

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

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