» Creating email address
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Joining the text values in columns A:C into a single string of the following format:
FirstName.LastName@Domain.com
Solution:
Use this joining formula:
=A2&"".""&B2&""@""&C2&"".com""
Or a similar CONCATENATE formula:
=CONCATENATE(A2,""."",B2,""@"",C2)
Example:
First Name______Last Name_____Domain_____Full Address
George__________Bush__________Hotmail____George.Bush@Hotmail.com
Michael_________Jordan________Gmail______Michael.Jordan@Gmail.com
Jerry___________Seinfeld______Yahoo______Jerry.Seinfeld@Yahoo.com
Book Store:
[SOLVED] Creating email address
Frank
If you add "Mailto:" at the beginning of the CONCATENATE and surround the entire formula with =HYPERLINK, then you can click on the cell and Outlook will create a new message with that person's emial in the To: Line. Also, "&Subject=" will add the subject line and "&Body=" will write part of the e-mail. Add both of these after the e-mail address.
Combine text with formula results
David Briggs
This allowed me to add text before (and after) a lookup formula.
I.E.
=CONCATENATE("Costs for ",VLOOKUP(G24,Table,2,0)," AFTER TEXT")
gave me
"Costs for Southampton AFTER TEXT"
Thanks
Hyperlinking E-mail
GAYATHRI
EXCELLENT.VERY USEFUL
I want to open a new email adress
Pearl B
I want to have an email address. Please create for me
help
stephanie
i desperately need to create an e~mail address so that i can chat
Help please
Martin
I dont know how to create an email adress
formula & function
Jeevan Sarker
Goodday !
I would like to figure out the actual birth date on ms excel.Sometimes i face problems I would like to get soluation from you and the sites by mail.
Plz advise
Jeevan
