Creating email address with data from cell

Closed
Jen - Sep 1, 2010 at 04:42 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 1, 2010 at 06:44 PM
Hello,

Thank you in advance for your help with this.

I have a column that contains the first and last names of people. I need to create a column with their corresponding email addresses as follows: firstname.lastname@company.com. Is there a way to automatically create the email addresses by using the names in the first column?

Thank you for your help!!

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 1, 2010 at 06:44 PM
if the first name and the last name are in the same column then , you need to replace space with a "." and then add the "company.com"

=A1 & "@company.com"
or

=SUBSTITUTE(B4," ",".",1) & "@company.com"
0