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" <Zitaos.291ofy_1149705001.6646@excelforum-nospam.com>
wrote in message
news:Zitaos.291ofy_1149705001.6646@excelforum-nospam.com...
>
> 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:
>
> |aanderson@company.com|
> |bdarius@company.com|
> |ceffrum@company.com|
> |dbladenly@company.com|
>
> 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
>