Use the ampersand & character instead of the CONCATENATE function. The ampersand (&) calculation operator lets you join text items without having to use a function.

You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function. Select the cell where you want to put the combined data. Type = and select …

To combine numbers, use the CONCATENATE or CONCAT, TEXT or TEXTJOIN functions, and the ampersand (&) operator. In Excel 2016, Excel Mobile, and Excel for the web, …

When you combine values from multiple fields into a new string, you may want to include a value in the new string (such as a comma) only when data exists in a particular field. To conditionally …

To combine first and last names, use the CONCATENATE function or the ampersand (&) operator.

Using parentheses allows you to change that calculation order. There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.

This is the opposite of concatenation, in which you combine text from two or more cells into one cell. For example, you can split a column containing full names into separate First Name and …

The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments. CONCAT replaces the CONCATENATE function. …

Text concatenation operator Use the ampersand (&) to concatenate (combine) one or more text strings to produce a single piece of text.

You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function. Select the cell where you want to put the combined data. Type = and select …

To combine numbers, use the CONCATENATE or CONCAT, TEXT or TEXTJOIN functions, and the ampersand (&) operator. In Excel 2016, Excel Mobile, and Excel for the web, …