|  

» 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

Screenshot // Creating email address
Creating email address
Rate This Tip
12 34 5
Rating: 2.76     Views: 98015
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments