How to Concatenate Strings in Excel

In this tutorial, we are going to learn how to concatenate (combine) two or multiple strings in Microsoft Excel spreadsheets or any other similar applications.

Pre-requisites:

    1. The reader is assumed to have a background in using basic functions in excel.

Every content of a cell in an excel spreadsheet is considered a string.

To combine two strings, we use the '&' ampersand operator:

Let's try it in excel.

Suppose we have a string in cell A1 and cell B1 and we would like to display the combined strings in cell C1, we will enter the below formula in cell C1:

The output will be something like below:

Below is a sample of concatenating more than two strings:

Play with it to achieve your specific goals and have fun...