Automate an email address from a name

Solved/Closed

Lil-Mogwai Posts 13 Registration date Friday June 11, 2010 Status Member Last seen December 6, 2010 - Dec 3, 2010 at 09:55 AM
Lil-Mogwai Posts 13 Registration date Friday June 11, 2010 Status Member Last seen December 6, 2010 - Dec 6, 2010 at 05:59 AM

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

Automate an email address from a name
No email no password - Guide
Create a yahoo email address - Guide
How to change email address on netflix - Guide
Garena email address - Guide
Postal address of my location - Guide

2 responses

Answer 1 / 2

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 6, 2010 at 04:44 AM

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.

Answer 2 / 2

Lil-Mogwai Posts 13 Registration date Friday June 11, 2010 Status Member Last seen December 6, 2010
Dec 6, 2010 at 05:59 AM

Thanks Very much for your help.

Similar discussions

my facebook hacked and disabled

i can't enter to my account facebook

someone hacked my fb account and changed my password

Similar discussions

Subscribe To Our Newsletter!