Creating email address

My Account

Check out

Shopping Cart

JOIN OUR NEWSLETTER
and receive for joining:
	Free eBook Learn More!
	Free Excel ADD-IN
	Free Weekly Excel Tip








F1 eBook (Spanish)

» 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

Rate this tip



1	2	3	4	5

RATING: 3.07
VIEWS: 36507

Email Tip

Print Tip

Add to My Tips

READER COMMENTS (view all comments)

Hyperlinking E-mail
Frank wrote on December 31, 1969 19: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 19: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 19:00 EST

EXCELLENT.VERY USEFUL

I want to open a new email adress
Pearl B wrote on December 31, 1969 19:00 EST

I want to have an email address. Please create for me

help
stephanie wrote on December 31, 1969 19:00 EST

i desperately need to create an e~mail address so that i can chat

Help please
Martin wrote on December 31, 1969 19:00 EST

I dont know how to create an email adress

formula & function
Jeevan Sarker wrote on December 31, 1969 19: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

Personal Finance for Dummies

The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner

Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon

Final Accounting: Ambition, Greed and the Fall of Arthur Andersen

Excel Charts

Microsoft Excel 2002 Simply Visual

RELATED MICROSOFT EXCEL TIPS

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books

VIEW ALL BOOKS

	Advertise With Us
Tips	Add-In in VBA \| Applications - Word, Outlook in VBA \| Array Formulas \| Cells, Ranges, Rows, and Columns in VBA \| Counting \| Custom Functions \| Custom Functions in VBA \| Database Formulas \| Database in VBA \| Date & Time Formulas \| Date & Time in VBA \| Events in VBA \| Excel 2003 \| Excel Chart \| Excel Consolidating \| Excel Counting \| Excel Custom Functions using VBA \| Excel Customizing \| Excel Data \| Excel Dates \| Excel Editing \| Excel Files \| Excel Filter \| Excel Format \| Excel Formula \| Excel General \| Excel Grouping and Outlining \| Excel Importing Text Files \| Excel Information \| Excel Keyboard Shortcuts \| Excel Loan Formulas \| Excel Macros - VBA \| Excel Pivot Tables \| Excel Printing \| Excel Range Name \| Excel Security - Protection \| Excel Sorting \| Excel Style \| Excel Subtotals \| Excel Summing \| Excel Text \| Excel Time \| Excel Tools \| Excel Worksheet, Workbook \| Files, Workbook, and Worksheets in VBA \| Financial Formulas \| Formating in VBA \| General Topics in VBA \| Import and Export in VBA \| Information Formulas \| Keyboard & Other Shortcuts in VBA \| Keyboard Formula Shortcuts \| Links between Worksheet and Workbooks \| Links in VBA \| Logical Formulas \| Lookup Formulas \| Mail - Send and Receive in VBA \| Menus, Toolbars, Status bar in VBA \| Modules, Class Modules in VBA \| Other Q&A Formulas \| Printing in VBA \| Protecting in VBA \| Summing \| Text Formulas \| User Forms, Input boxes in VBA \| Using Loops \| Working with Formulas \|
Tips by Version	Microsoft Excel 97 \| Microsoft Excel 2000 \| Microsoft Excel 2002 \| All Microsoft Excel Versions \| New in Excel 2002 \| New in Excel 2003 - Office 11
Website	Home \| Tip of Hour \| Recommended Tips \| Most Viewed Tips \| Tips by Version \| Submit a Tip \| My Tips Microsoft Excel Tutorials \| Excel Links \| Write for Us \| About Us \| Search Results \| Tip Archives \| Excel Forum \| Excel Forum Archives
Excel Book	Excel 97 Book \| Excel 2000 Book \| Excel 2002 Book \| Excel XP Book \| Book Store

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.
Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation Site Developed By: Varien