Trying to create a formula for email

[fiveholts]

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!

[#2]

@fiveholts 

Try

=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.