» 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:
Recommended Books:
- The One Page Business Plan: Start With a Vision, Build a Company!
- Microsoft Access 2002 for Dummies
- The New Financial Order: Risk in the Twenty-First Century
- Financial Risk Manager Handbook, Second Edition
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
Hyperlinking E-mail
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
