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
Lil-Mogwai Posts 13 Registration date Friday June 11, 2010 Status Member Last seen December 6, 2010 - Dec 6, 2010 at 05:59 AM
Related:
- Automate an email address from a name
- Free fire gmail address - Guide
- No email no password - Guide
- Phone ip address - Guide
- Dns address could not be found android - Guide
- Postal address of my location - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 6, 2010 at 04:44 AM
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.
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.
Lil-Mogwai
Posts
13
Registration date
Friday June 11, 2010
Status
Member
Last seen
December 6, 2010
Dec 6, 2010 at 05:59 AM
Dec 6, 2010 at 05:59 AM
Thanks Very much for your help.
