Two name comma separated in single cell to "email address"

**jf44** · 03-06-2013, 09:10 PM

I have this in a single cell "lastname, firstname"

Eg:

"smith, john"

*Note there is a a SPACE between the comma and second work in the cell "smith, john"

I'm looking for these outputs:

firstname.lastname@email.com or john.smith@email.com

first letter (of firstname)lastname@gmail.com or jsmith@email.com

Any help would be great.

Thanks.

**rcm** · 03-06-2013, 09:15 PM

look at row 15 for the formulas

**FDibbins** · 03-06-2013, 09:25 PM

Hi and welcome to the forum

for the full name, try this...
=MID(A1,SEARCH(",",A1,1)+2,99)&"."&LEFT(A1,SEARCH(",",A1,1)-1)&"@email.com"
fir just the 1st initial, try this...
=MID(A1,SEARCH(",",A1,1)+2,1)&LEFT(A1,SEARCH(",",A1,1)-1)&"@email.com"

**jf44** · 03-06-2013, 10:03 PM

There is an issue after A1. In A2 down it ends up as john .smith@email.com and j smith@email.com.

**SDCh** · 03-06-2013, 10:51 PM

Try this :

Please Login or Register  to view this content.

Two name comma separated in single cell to "email address"

LinkBack

Thread Tools

Rate This Thread

Display

Two name comma separated in single cell to "email address"

Re: Two name comma separated in single cell to "email address"

Re: Two name comma separated in single cell to "email address"

Re: Two name comma separated in single cell to "email address"

Re: Two name comma separated in single cell to "email address"

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions