Automate an email address from a name

Solved/Closed
Report
Posts
13
Registration date
Friday June 11, 2010
Status
Member
Last seen
December 6, 2010
-
Posts
13
Registration date
Friday June 11, 2010
Status
Member
Last seen
December 6, 2010
-
Hello,
I have a list of names, (first and sirname) in Cell A1.
In cell A2 i would like excel to populate the email address by getting the name in cell A1, adding a dot in the middle, then adding @eaton.com. I would like this to happen for all the names without me typing each email address seperatly.

Can this be done? Thanks

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
I presume there is one space between the first name and second name.

suppose the data is from names are from A1 down. In b1 copy this formula

=LEFT(A1,SEARCH(" ",A1)-1)&"."&RIGHT(A1,LEN(A1)-SEARCH(" ",A1))&"@eaton.com"

you can copy this formula down if there are data in A2,A3 etc.
Posts
13
Registration date
Friday June 11, 2010
Status
Member
Last seen
December 6, 2010

Thanks Very much for your help.