A common task in Excel is combining text that is stored in separate cells into a single cell – and there’s more than one way to do it.

Take the list below. Each row contains the Title, First Name and Surname of an employee. This information is stored in 3 columns. The requirement is to combine the 3 elements together into a single column, with a space between each element…

In this video I cover FOUR methods of combining text: Formula with ampersand; the CONCAT function, the CONCATENATE function and the TEXTJOIN function.

Learn about the benefits and differences of each method.

Links to the video and individual sections below…


Combine text using a formula (the ampersand method)

Combine text using the CONCAT function

Combine text using the TEXTJOIN function

Combine text using the CONCATENATE function