How to use the CONCAT function in Excel (vs the CONCATENATE function)

Learn how to use the CONCAT function in Microsoft Excel (vs the CONCATENATE function). This tutorial demonstrates how to use Excel CONCAT to concatenate values together with an easy to follow example and step-by-step instructions. We also provide a comparison of the CONCAT function with the CONCATENATE function. The CONCATENATE function is an older Excel function that the CONCAT function is intended to replace.

CONCAT Function (and sample data):

CONCATENATE Function:

Excel Tutorials:

Don't forget to subscribe to our channel for more great Excel tutorials!

or follow us on:

[cakemartyr]

Great being able to specify a range. Frustrating how this never was originally in Excel given it is such an intuitive notion.

[Abdullah-cdsz]

Very well explained, can you make more videos of other Microsoft office products.

[ratandart]

THANK YOU! I was browsing for other methods because the =concatenate(transpose method didn't work as my F9 key wouldn't work. This is so much eaier

[marsch]

What if I want to leave a space in between?

[WorldlyMusi]

This has been very helpful, but it was missing one vital step for me, once I finish concatenate, I want to delete the source columns, and since the formula is still there I can't just delete the columns. What I do is copy the new concatenate column and then in a new column I "Paste Special" and choose to paste the column as a value. This one I can delete the source columns.

[walterjohnson]

How do we separate the concatenated values by a comma?