Thanks Sandy - I knew there was a reason for steering clear of a
formatting solution, but I had a nagging doubt when I saw Elkar's
solution.

I suppose if the end part of the address is always the same, then the
OP could save a column and just have:

"

in B1 and copy down.

Pete

On Oct 9, 11:55 pm, "Sandy Mann" wrote:
If you use formatting to add the last part of the address then you will not
be able to us it to create an email. For instance if you format the cell as
custom format:

"

then enter in the cell sandymann2, you will see in the cell:



but in the formula bar, which shows what is really in the cell all youwill
see is the sandymann2 which you entered.

Better to use Pete_UK's suggestion.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"crazyj" wrote in message

...



I need to type in e-mail addresses for everyone at work, and we have more
than 1,000. Is there a format I can create that will add the last part of
the e-mail (which is the same for everyone) to what I type? (similar to
typing in #'s and having the dollar sign added)- Hide quoted text -

- Show quoted text -