How to Concatenate with Space in Excel (3 Suitable Ways)

To demonstrate how to use the concatenate function, we will use a dataset with the First Name, Middle Name, and Last Name columns. We will apply the CONCATENATE, TEXTJOIN functions, and Ampersand (&) symbol.

Read More: How to Concatenate with Delimiter in Excel

Method 1 – Use Ampersand(&) Symbol to Concatenate with Space

The simplest way to concatenate all the names into a single cell and add space between each name is to use the Ampersand (&) symbol. Here is how to do it.

Steps:

• Select a cell (i.e., E5) first.
• Apply the following formula to that cell:

• Press ENTER to see the output.

• Use Fill Handle to AutoFill the remaining cells in column E.

Read More: How to Concatenate Apostrophe in Excel

Method 2 – Use the CONCATENATE Function to Concatenate with Space

The second way to concatenate with space in Excel is by using the CONCATENATE function. Here are the steps.

Steps:

• Enter the following formula in a selected cell.

• Hit the ENTER button.

• Drag the Fill Handle to copy the formula to the remaining cells in column E.

Read More: How to Bold Text in Concatenate Formula in Excel

Method 3 – Employ the TEXTJOIN Function to Concatenate with Space

When you need to combine a large number of cells, using the Ampersand (&) symbol or the CONCATENATE function may be a bit troublesome. Instead, you can use the TEXTJOIN function. Follow the steps below to learn how.

Steps:

• Select your destination cell (i.e., E5).
• Enter the following formula in that cell:

• Press ENTER to see the output.

• AutoFill the TEXTJOIN function to the remaining cells in column E.

Read More: How to Concatenate Cells but Keep Text Formatting in Excel

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Further Readings

• CONCATENATE vs CONCAT in Excel
• Excel CONCATENATE Showing Formula Not Result
• Concatenate Not Working in Excel
• Opposite of Concatenate in Excel