Automate an email address from a name
Solved/Closed
Lil-Mogwai
Posts
13
Registration date
Friday 11 June 2010
Status
Member
Last seen
6 December 2010
-
3 Dec 2010 à 09:55
Lil-Mogwai Posts 13 Registration date Friday 11 June 2010 Status Member Last seen 6 December 2010 - 6 Dec 2010 à 05:59
Lil-Mogwai Posts 13 Registration date Friday 11 June 2010 Status Member Last seen 6 December 2010 - 6 Dec 2010 à 05:59
Related:
- Automate an email address from a name
- Change email address facebook - Guide
- How to change outlook email address - Guide
- Address details from pan number - Guide
- Structure of an email - Guide
- Thunderbird email signature - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
6 Dec 2010 à 04:44
6 Dec 2010 à 04:44
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 11 June 2010
Status
Member
Last seen
6 December 2010
6 Dec 2010 à 05:59
6 Dec 2010 à 05:59
Thanks Very much for your help.
