formatting cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Select a Custom Format for your cell range, then enter:

@\@"your_domain_name"

HTH,
Elkar
 
Why don't you put the second part in column B and copy down, then use
column A for the first part and then concatenate A and B in column C?
Fix the values in column C then delete the first two columns.

Hope this helps.

Pete
 
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:

@"@mailinator.com"

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

(e-mail address removed)

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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:

=A1&"@whatever.com"

in B1 and copy down.

Pete
 
Back
Top