One way

",A2&"@t hislocation.com")

copy down

Regards,

Peo Sjoblom

"Sue" wrote:

I have about 500 cells in 1 column where i need to add the same email address
domain for example - cell A2 reads Sue, cell A3 reads Bob, cell A4 reads Tom
(on down for about 500 cells). I need to simply add @thislocation.com to each
of them - so I wants A2 to read , A3 to read
, A4 to read - help? I also need
each of these cells to be active email links. (which u can't get if you add
the @thislocation.com to each cell - you have to add it in the formula area
at the top).

Thanks