Consolidate
in [General]
|
Prev: how do you circle an item on an excel document
Next: Excel 2007 display and print are different for different users
From: bobby769 on 5 Feb 2010 16:02 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 firstnamelastname(a)domainname.com Thanks in Advance
From: Dan on 5 Feb 2010 16:36 if this is idea looking for, without modifyiing A, in a new column: =A9&"@email.com" 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 > firstnamelastname(a)domainname.com > > Thanks in Advance
From: "David Biddulph" groups [at] on 5 Feb 2010 16:37 =A1&"@domainname.com" 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 > firstnamelastname(a)domainname.com > > Thanks in Advance
From: Dave Peterson on 5 Feb 2010 16:57 You may want to try a formula like: =hyperlink("mailto:" & a1 & "@domainname.com","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 > firstnamelastname(a)domainname.com > > Thanks in Advance -- Dave Peterson
From: bobby769 on 8 Feb 2010 10:25
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 > firstnamelastname(a)domainname.com > > Thanks in Advance |