Concatenate Excel Tutorial

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

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.

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

[florinabn]

Gosh you made this seem so easy, I can't believe it. Had someone at work showing us concatenate in suuuuch a complicated way that I could never remember all those steps. Thank you!

[SaucyWench]

I've been through about 10 videos on this and this is the first one that works, and is easy to understand, without taking 25 minutes. Thank you. Subscribed.

[XCreepyStix]

thankyou for making a video that doesnt involve time wastage and teaches stuff in such a easy way! Subscribing

[deecable]

Thank you, I spent hours last night trying to figure out how to concatenate. I watched your video and did it in 10 minutes! YOU can teach an old dog new tricks :)

[nobinpradhan]

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.

[richardvilla]

Thank you Kevin! For anyone whose brain computes any excel instruction into mental fog, this guy is your savior.

[tifaldhiedu]

Thanks God I saw this content, really helped me create a simple content for the needs of children during the pandemic, every mother suffer and back to school for two years now.... 😂😂😂😂😂😂

[stahl_gaming]

Dude, you saved my day fro tomorrow I'll never tell to my boss about this function :D

[SamapanSarkarSam]

This is the 2nd video of yours which I have used to brush up on my Excel skills which had become rusty. The previous video was about Basic Excel Shortcuts. This video was precise, simple to follow and very helpful. Thanks Kevin and keep sharing your videos and I have subscribed to your channel so that I do not miss them. Take care and stay safe during these trying times.

[francisvernelus]

Seen so many vids but yours the one that helped the most

[anamikajoshi]

You are a savior! Glad your following is increasing!

[Lauren-yuxk]

Thank you Kevin. I really needed this. Thanks for taking the time to explain this perfectly.

[jamesgraham]

Genius! I'm getting better everyday because of this channel

[samuddhipunchihewa]

Thank you Kevin. I have been suffering with this until now.

[marksummers]

Another GREAT resource for aspiring executives is a piece titled The Hatchet Man's Playbook - a LOT of eye-popping, non-obvious stuff! Can't recommend it highly enough!

[benniecontreras]

thanks for the easy explanation of concatenate function. seems im always learning something new with excel great job

[jimbekind]

Wish you had not blown past "make that an absolute reference"??? What? How?
Your vids are very helpful and also make me want 🍪 🍪.

[farhanarahman]

How I can do CONCAT when I have different format in Column A (Bold text) and Column B (Italic Text), and I want to keep that difference in column C?

[pulakjena]

Your training is superb bro .. appreciated a lot 😊

[vaddenata]

Thank you, it's really helpful 😊