Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting cells
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting cells
Select a Custom Format for your cell range, then enter:
@\@"your_domain_name" HTH, Elkar "crazyj" wrote: 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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting cells
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 On Oct 9, 10:46 pm, crazyj wrote: 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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting cells
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) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting cells
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells | Excel Discussion (Misc queries) | |||
formatting cells | Excel Discussion (Misc queries) | |||
Formatting cells | Excel Discussion (Misc queries) | |||
Formatting Cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions |