Create email address from Last Name, First name

[DoodlesMama]

Hello - I'm wondering if there is a way to create and email address from a single cell containing Last Name, First Name without splitting it into two separate columns first? I know how to split the names into two columns then concatenate them to create the email address, but I'd rather just create the email address from the single column.

Any help will be greatly appreciated!

For Example

Name	Email
Smith, Penny	penny.smith@email.com

[AlKey]

Try this

Please Login or Register  to view this content.

v	A	B
1	Smith, Penny	smith.penny@email.com

[sandy666]

Just SUBSTITUTE enough, upper or lower case doesn't matter in email address

[AlKey]

Or with reversed name

Please Login or Register  to view this content.

v	A	B
1	Smith, Penny	penny.smith@email.com

[Phuocam]

One way:

=LOWER(TRIM(MID(A1&"."&A1,FIND(",",A1)+1,LEN(A1))))&"@email.com"

[DoodlesMama]

Thank you so much AlKey! It worked perfect!!!

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.