Need help on a formula

[Sharon]

I need a formula that will take the following information from cell A3
and populate it in A4.

Here is the information in A3 - jones123456

I need a formula in A4 that will take the info in A3 and create an
email address that has the last name AND the last 3 digits of the
number, plus the domain.... so that the data will read in A4 -
(e-mail address removed).

I have the first part of the formula like I want it to populate the
last name =IF(A3=0,"",A3). But then I don't know how to get the last
3 digits of the number AND The domain name added to the last name in
A4. Here is what I need:

=IF(A3=0,"",A3) +last 3 digits + @gmail.com. (All of my numbers will
have 6 or 7 total digits).

Thanks for any help someone can give me!!!!

 

[Sharon]

Yes.. that works perfectly. Thank you!!!! This will help me populate
thousands of email addresses for students.