Tip Printed from ExcelTip.com

---

Creating email address


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