How to Join Text Strings in Excel ?

In this post, you will learn how to join two strings or multiple strings together in Excel. We will look at the use of ampersand (&) operator and TEXTJOIN function to accomplish these tasks.

Joining text strings –

One of the more basic text manipulation actions that you can do is joining text strings
together. In the example shown in Figure below, we are creating a full name column by
joining together first and last names.

This example illustrates the use of the ampersand (&) operator. The ampersand operator
tells Excel to concatenate values with one another. As you can see in Figure 11.1, you can
join cell values with text of your own. In this example, we are joining the values in cells B3
and C3 separated by a space (created by entering a space in quotes).

Excel 2019 introduces the new TEXTJOIN function to provide an easier way to handle more
complex scenarios. This new function requires just a few arguments:

TEXTJOIN(delimiter,ignore_empty_values,text)

The first argument is the character that you want placed between the cells that you are
joining. If you type a comma as the “delimiter,” the function will place a comma between
the joined values.

The second argument determines what to do when Excel encounters an empty cell. You can
either set this argument to TRUE, telling Excel to ignore empty cells, or set it to FALSE.