Concatenate excel

One of the most important operations in Excel formulas is concatenation. In Excel formulas, concatenation is the process of joining one value to another to form a text string.

How to combine text from two cells in excel

The values being joined can be hardcoded text, cell references, or results from other formulas.

There are two primary ways to concatenate in Excel:

1. Manually with the ampersand operator (&)
2. Automatically with a function like CONCAT or TEXTJOIN

In the article below, I'll focus first on manual concatenation with the ampersand operator (&), since this should be your go-to solution for basic concatenation problems.

Then I'll introduce the three Excel functions dedicated to concatenation: CONCATENATE, CONCAT, and TEXTJOIN. These functions can make sense when you need to concatenate many values at the same time. As with so many things in Excel, the most important thing is to understand the basics first. 

What is concatenation?

Concatenation is the operation of joining values together to form text.

For example, to join "A" and "B" together with co

how to concatenate columns in excel

how to combine cells in excel without merging