Applies To Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 Excel Mobile You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.

Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.

To combine numbers, use the CONCATENATE or CONCAT, TEXT or TEXTJOIN functions, and the ampersand (&) operator. Notes: In Excel 2016, Excel Mobile, and Excel for the web, CONCATENATE has been replaced with the CONCAT function.

In Microsoft Excel, you can use a macro to concatenate the data in two adjacent columns and to display the result in the column to the right of the columns that contain your data. This article contains a sample Microsoft Visual Basic for Applications (VBA) macro (Sub procedure) to accomplish this.

Creates a sentence by joining the data in column A with other text. Stream population for brook trout species is 32/mile. =CONCAT(B2," ", C2) Joins three things: the string in cell B2, a space character, and the value in cell C2. Andreas Hauser =CONCAT(C2, ", ", B2)

To combine first and last names, use the CONCATENATE function or the ampersand (&) operator. Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function.

CONCATENATE(text1,text2,...) Text1, text2,... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or column references. Remark. The "&" operator can be used instead of CONCATENATE to join text items. Example

With Power Query, you can merge two or more columns in your query. You can merge columns to replace them with a merged column, or create a new merged column alongside the columns that are merged. You can merge columns of Text data type only.

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

In the Function box, select the function that you want Excel to use to consolidate the data. To indicate where the labels are located in the source ranges, select the check boxes under Use labels in: either the Top row, the Left column, or both. In each source sheet, select your data.