I have been creating email addresses, the ID portion of which is formed from
. First letter of the first name, plus the
. First three letters of the last name, plus the
. Last four digits of social security number
Then I add @nsu.edu to complete the email address. I have been using the
CONCATENATE function in Excel 2000. For example, I enter

=CONCATENATE("A", "Jac". 8344, "@", "nsu.edu"), which gives the
email address
I have been doing it one email address at a time. Is there any way of doing
it faster? I have tried the AUtoFill and the Format Painter features without
success.
Last names, first names, and social security numbers occupy contiguous
columns.

I will appreciate your help. Thanks.