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

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