|
» Creating email address
CATEGORY: Excel Text Formulas |
VERSIONS: All Microsoft Excel Versions |
|
Problem: 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 |
| Screenshot // Creating email address |
  |
|
RATING:
3.03
VIEWS: 50662 |
||||
Hyperlinking E-mail
Frank wrote on December 31, 1969 18:00 EST
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 wrote on December 31, 1969 18:00 EST
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 wrote on December 31, 1969 18:00 EST
EXCELLENT.VERY USEFUL
I want to open a new email adress
Pearl B wrote on December 31, 1969 18:00 EST
I want to have an email address. Please create for me
help
stephanie wrote on December 31, 1969 18:00 EST
i desperately need to create an e~mail address so that i can chat
Help please
Martin wrote on December 31, 1969 18:00 EST
I dont know how to create an email adress
formula & function
Jeevan Sarker wrote on December 31, 1969 18:00 EST
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
Sponsors:
 |
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
