Combine Text From Multiple Cells in Excel

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…

Introduction

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