Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate
I have a list of over 2400 names in column A as
firstnamelastname They need to be turned into email addresses w/ the same domain name. How do I do this? Basically I need to turn into Thanks in Advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate
if this is idea looking for, without modifyiing A, in a new column:
" not sure if need to alter the name in email address, else repost with desired output and I will look at. "bobby769" wrote: I have a list of over 2400 names in column A as firstnamelastname They need to be turned into email addresses w/ the same domain name. How do I do this? Basically I need to turn into Thanks in Advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate
" and copy down.
-- David Biddulph bobby769 wrote: I have a list of over 2400 names in column A as firstnamelastname They need to be turned into email addresses w/ the same domain name. How do I do this? Basically I need to turn into Thanks in Advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate
You may want to try a formula like:
=hyperlink("mailto:" & a1 & ","Click me") And then the cell with this formula will be a hyperlink--just click it to start your default email client. bobby769 wrote: I have a list of over 2400 names in column A as firstnamelastname They need to be turned into email addresses w/ the same domain name. How do I do this? Basically I need to turn into Thanks in Advance -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate
Thank you all for your help.
Dan and David Biddulph's replies were the most helpful. "bobby769" wrote: I have a list of over 2400 names in column A as firstnamelastname They need to be turned into email addresses w/ the same domain name. How do I do this? Basically I need to turn into Thanks in Advance |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate
Glad it helped.
-- David Biddulph bobby769 wrote: Thank you all for your help. Dan and David Biddulph's replies were the most helpful. "bobby769" wrote: I have a list of over 2400 names in column A as firstnamelastname They need to be turned into email addresses w/ the same domain name. How do I do this? Basically I need to turn into Thanks in Advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help to consolidate data | Excel Worksheet Functions | |||
consolidate | Excel Discussion (Misc queries) | |||
Consolidate text | Excel Discussion (Misc queries) | |||
Consolidate | Excel Discussion (Misc queries) | |||
consolidate 2 different workbooks | Excel Discussion (Misc queries) |