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: https://1drv.ms/x/s!AmxrofZZlZ-whIZfJ…

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s