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:

[email protected] or [email protected]

first letter (of firstname)[email protected] or [email protected]

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 [email protected] and j [email protected].

**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