Excel Concatenate: Using Concatenate and Ampersand to Join Columns of Data in Excel

Excel Concatenate: Using Concatenate and Ampersand to Join Columns of Data in Excel

In this video, I'll show you how to use Excel concatenate formula as well as ampersand to concatenate and join data from multiple columns. This is useful for cleaning up data sets and converting data for upload into databases.

I don't use this formula often but like I said it's a great tool for data cleansing.

Concatenate is used to combine text strings and to split multiple cells and into one cell.
Other Resources and Links

CONCATENATE in Excel: combine text strings, cells and columns

Excel Formulas:
Using CONCATENATE to Combine Names

CONCATENATE function

The Excel CONCATENATE Function

MS Excel: How to use the CONCAT Function (WS)

MS Excel: How to concatenate strings together (WS, VBA)

Excel CONCATENATE Function

How to Concatenate Text in Microsoft Excel

Concatenate in Excel – Explained

How to Concatenate in Excel to Combine Text Strings

[ghiramm]

How to do this using VBA? If, for example, I need to combine column R + N from sheet 1 and result should be displayed in sheet 2, column A?