Using CONCATENATE function to create email addresses from a list

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 [email protected]
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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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 [email protected]
> 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.
>
>

If the first name is in A2, the last name in B2, and the SSN in C2...

In D2 enter & copy down:

=UPPER(LEFT(A2))&PROPER(LEFT(B2,3))&RIGHT(C2,4)&"@nsu.edu"

should do the job.

Almamba wrote:
> 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 [email protected]
> 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.
>
>