Combine first name and last name in Excel | create email addresses for example

This is a quick tutorial on how to combine first name and last name in Microsoft Excel. You might want to create email addresses from your list of names for example, so use the CONCATENATE function.



Syntax

=CONCATENATE(text one; text two; text three...)

Example


To create an email address from first name and last name we would do (assuming the names are in cells A1 and B1):

=CONCATENATE(A1;".";B1;"@company.com")

Note: depending on your regional settings, you might have to use comma (,) as a separator instead of semicolon (;):

 =CONCATENATE(A1,".",B1,"@company.com")

There you have it, Firstname.Lastname@company.com.

Change it to lowercase


=LOWER(CONCATENATE(A1;".";B1;"@company.com"))
 Use the SUBSTITUTE function to change characters like ö, ä, å or ü. I have written intructions for you right here.

2 comments:

  1. Thanks for a very interesting blog. What else may I get that kind of info written in such a perfect approach? I’ve a undertaking that I am simply now operating on, and I have been at the look out for such info. find contact details

    ReplyDelete
  2. AWS Training in Bangalore - Live Online & Classroom
    myTectra Amazon Web Services (AWS) certification training helps you to gain real time hands on experience on AWS. myTectra offers AWS training in Bangalore using classroom and AWS Online Training globally. AWS Training at myTectra delivered by the experienced professional who has atleast 4 years of relavent AWS experince and overall 8-15 years of IT experience. myTectra Offers AWS Training since 2013 and retained the positions of Top AWS Training Company in Bangalore and India.


    IOT Training in Bangalore - Live Online & Classroom
    IOT Training course observes iot as the platform for networking of different devices on the internet and their inter related communication. Reading data through the sensors and processing it with applications sitting in the cloud and thereafter passing the processed data to generate different kind of output is the motive of the complete curricula. Students are made to understand the type of input devices and communications among the devices in a wireless media.

    ReplyDelete