Adding same information to many cells...

[Zitaos]

I have about 1100 usernames for our organization, they are in the cells like this:

|aanderson|
|bdarius|
|ceffrum|
|dbladenly|
and so on....

I want to add the rest of the email address to these for print, so:

|[email protected]|
|[email protected]|
|[email protected]|
|[email protected]|

how can I add "@company.com" to all these cells without going into each cell and typing it in?

Thanks.

[Chip Pearson]

In the first cell, use a formula like

=A1&"@company.com"

Then copy this down as far as you need to go.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Zitaos" <[email protected]>
wrote in message
news:[email protected]...
>
> I have about 1100 usernames for our organization, they are in
> the cells
> like this:
>
> |aanderson|
> |bdarius|
> |ceffrum|
> |dbladenly|
> and so on....
>
> I want to add the rest of the email address to these for print,
> so:
>
> |[email protected]|
> |[email protected]|
> |[email protected]|
> |[email protected]|
>
> how can I add "@company.com" to all these cells without going
> into each
> cell and typing it in?
>
> Thanks.
>
>
> --
> Zitaos
> ------------------------------------------------------------------------
> Zitaos's Profile:
> http://www.excelforum.com/member.php...o&userid=35197
> View this thread:
> http://www.excelforum.com/showthread...hreadid=549612
>

[Zitaos]

Thank you very much for the quick reply.