» Creating email address
CATEGORY - Excel Text Formulas
VERSION - 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
Book Store:
Recommended Books:
- The Analysis and Use of Financial Statements
- Adventure Capitalist: The Ultimate Road Trip
- Finance and Accounting for Nonfinancial Managers
- Understanding Financial Statements
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Windows XP Pocket Reference
No comments have been submitted.
