Sue,

It could be done with a macro. Here's another way, though it'll take a
little while.

In an adjacent cell, put =A2 & ". Copy down with Fill
Handle. You should see . Now select all this stuff,
Copy. Now select A2, Edit - Paste special - Values. At this point, you can
trash the formula column. Now it gets a little tedious. Start in A2, and
repeatedly press F2, Enter, working your way down. Each should now be in
blue, and be a workable email hyperlink.

If you're willing to put in a macro, we'll write you one. Someone has
probably done that by now anyway.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Sue" wrote in message
...
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