Concatenate Excel Tutorial

Learn how to combine cells in Microsoft Excel using the concatenate function in this step-by-step tutorial.

Access the sample data that I use in this video here:

The CONCATENATE function joins two or more text strings into one string.

In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.

=CONCATENATE (text1, text2, [text3], …)

In this video, I use the latest version of Microsoft Excel that comes with Office 365. However, this should work with older versions of Excel as the concatenate function has been available in past versions of Excel.

See all Excel tutorial videos here:

As full-disclosure, I work at Microsoft as a full-time employee.


Xem thêm bài viết khác:

Article Categories:
Tổng Hợp


  • I love the voice and the pretty face and the intelligent brain of yours Kevin. More power!

    Cheng Macalino June 13, 2020 12:02 am Reply
  • Thanks a ton, Kevin. Your lesson is as precious as a million dollar lottery ticket. I am going to save 100s of manhours because of your lesson. I am an online tutor ,by the way. Thanks once again.

    Nobin Pradhan June 13, 2020 12:02 am Reply
  • thanks Kevin.

    San Fran June 13, 2020 12:02 am Reply
  • nice video

    RAHUL GULSHAN June 13, 2020 12:02 am Reply
  • Hello,

    Could you possibly do a tutorial for using or creating forms in excel?
    Thank you from LB, CA

    Isabel Zuniga June 13, 2020 12:02 am Reply
  • Hi kevin.
    Love your tutorials.
    May i kindly ask if you have made a video for ;

    How to copy the same number to bottom or upper cell of the same (right) coiloum.
    If the left couloum have the same uid.
    Its okay if excel cant do this.
    Thxx a lot kevin.

    Willi 1994 June 13, 2020 12:02 am Reply
  • Gentlemen hello;

    I was wondering if anyone around knows how to resolve the following problem of concatenation. Here below is a formula I wish to concatenate with some other text.


    The formula constructs a string representing a mathematical derivative (but it could be any other thing as simple as a fraction).

    Note that the ="dy" portion is underlined by means of each character preceded with UNICODE hex 035F, aka; "Combining Double Macron Below". Then follows the concatenation of &UNICHAR(10) and &"dy".

    Then, after formating the containing cell to Vertically Align to the Middle and to "Wrap Text" it creates the appearance of the Leibniz's notation. (It really looks nice on a spreadsheet!)

    However, there is one major problem! I could not find a technique to concatenate an equal sign after the fraction bar.

    I've tried using &UNICHAR(13) (i.e.; "Carriage Return" and other legacy ASCII control characters). Furthermore, even placing the "=" sign in a different cell, and then concatenating once again only produces the "=" to follow behind the denominator and not as I would hope of being behind the fraction bar.

    Does anyone know of a workaround?

    Nelson Semino June 13, 2020 12:02 am Reply
  • Thank you bro!!!! ✊😁😁

    mbuso ntuli June 13, 2020 12:02 am Reply
  • I have done this function so many times and for hours I have worked on one spreadsheet. What am I doing wrong? I have my formula typed in and when I drag it down it just brings up- the very first one. They are not changing as I drag the formula.

    Carla Snow June 13, 2020 12:02 am Reply
  • Thank you for sharing this very helpful tip. Is there an easy way to split the names in two separate columns? Say we have Kevin Startvert in one column but I need to separate the first and last name.

    Kuldeep Sah June 13, 2020 12:02 am Reply
  • Thank you so much Kavin for sharing this.

    Wasim Ahmed June 13, 2020 12:02 am Reply
  • I dont know why he seems like ryan seacrest haha

    Patrick Pellegrino June 13, 2020 12:02 am Reply
  • Can you elaborate on joining or link seperate spread sheet from different pages together. Thanks for your good work.

    Juliet Gall June 13, 2020 12:02 am Reply
  • Kevin,
    Hey I have a question for you man.
    Can you do a tutorial on how you (Specifically You) record your audio and how you edit? Please.
    PS: I've only watched 2 episodes and i'm hooked.
    I love your videos/anything and everything to do with Tech and electricity.

    Auryo June 13, 2020 12:02 am Reply

Leave a Comment

Your email address will not be published. Required fields are marked *