Trying to create a formula for email

Occasional Visitor

I need to take a name:

Sally Smith

 and create her email in another cel. The email is sasmith@.... .com

So first two initials and last name

I've tried the =LEFT(A2,2) AND LEFT(A2,1)

Using CONCATENATE but it's not working?? Help!

Thank you!


1 Reply




=LEFT(A2,2)&MID(A2,FIND(" ",A2)+1,100)&"@... .com"


Remark: this will fail for persons named like


Sally Anne Smith


Let me know if you need to handle that.