The simple syntax for the CONCATENATE function is: The Excel syntax for the CONCATENATE function is: With the CONCATENATE function, you simply include the items you want to combine in the arguments. Using the CONCATENATE function, you can combine multiple cells and add other text or items in the expression. You can also use the CONCATENATE function to combine cells into one cell using a formula. Combining cells using the CONCATENATE function = " " you are creating structured reference formulas in Excel tables, it's easier if the field names do not include spaces.
If there are no spaces in the field names, you can enter the following formula in C2 in the table as follows: In the table example below, the structured reference formula using the CONCATENATE operator is entered in C2 and Excel color codes the references: In the following example, we've entered a formula in C2 in an Excel table and pressed Enter (Excel will populate the table column Name]] &" " Name]] In the following example, we've entered a formula =A2 &" " &B2 in C2 and then copied the formula down to the cells below by dragging the Fill handle on the bottom right corner of the cell: If you wanted to add a space between the data, you would enter the following formula in C2: If you want to add text, enter it in quotation marks or double quotes.įor example, if you wanted to combine the data from cells A2 and B2 (such as first name and last name), you could enter the following formula in C2: Repeat for other cells or items you want to add.Type the cell reference for the cell you want to combine or click it.Type the CONCATENATE operator (&) by pressing Shift + 7 (at the top of the keyboard).Type the cell reference for the first cell you want to combine or click it.Select the cell where you want to insert the combined data.To combine cells by entering a formula in Excel using the CONCATENATE operator: In order to use the CONCATENATE operator, you will need to include it the formula each time you want to add something new to the expression. Using the CONCATENATE operator, you can combine multiple cells and add other text or items in the expression. You can use the CONCATENATE operator (&) to combine cells into one cell using a formula. Combining cells using the CONCATENATE operator (&) You would also need to precede the field name with to refer to the current record. If you want to enter formulas in an Excel table, you can use structured reference formulas which must refer to fields in square brackets. If you want to combine dashes, commas, spaces or other text in an expression with CONCATENATE, you need to enter it in quotation marks or double quotes (such as " ").
In this article, we'll look at 3 ways to combine cells using CONCATENATE:
Recommended article: How to Merge Cells in Excel (4 Ways)ĭo you want to learn more about Excel? Check out our virtual classroom or in-person Excel courses > It is important to note that combining cells is different from merging cells. If you have Excel 2019 or a later version, you can also use the CONCAT function. CONCATENATE is often used to combine text in cells (like first name and last name) but you can also combine text with numbers, dates, functions, spaces, commas or dashes. You can combine the data from multiple cells into another cell using the CONCATENATE operator or CONCATENATE functions. Combine Data in Cells Using the CONCATENATE Operator or Functionsīy Avantix Learning Team | Updated February 20, 2022Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019, 2021 and 365 (Windows)