Column A = Last name
Column B = First name
Column C = S/S num
Enter this in D2 and copy down as needed:
=LEFT(B2)&LEFT(A2,3)&RIGHT(C2,4)&"@nsu:edu"
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Almamba" wrote in message
...
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.