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

Concatenating in Excel is one of the most useful tools available to Excel users. It allows you to join two or more cells together in order to form a unified value. This can be particularly useful for combining data from multiple sources into a single value. In this article, I am going to explain 3 suitable ways on the topic of how to concatenate with space in Excel. I hope it will be helpful for you if you are looking for a similar sort of thing.

Download Practice Workbook

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

3 Suitable Ways to Concatenate with Space in Excel

In order to concatenate with space, I am going to discuss 3 suitable ways in the following section. For more clarification, I am going to use a dataset with the First Name, Middle Name, and Last Name columns. We will apply the CONCATENATE, TEXTJOIN functions, and Ampersand (&) symbol as well to concatenate cells with space, Here’s an overview of the dataset for our today’s task.

1. Use Ampersand(&) Symbol to Concatenate with Space

The simplest way to concatenate with space is to use the Ampersand (&) symbol. In the following section, we will use the Ampersand (&) symbol to concatenate all the names into a single cell with spaces.

Steps:

• Select a cell (i.e. E5) first.
• Next, input the following formula in that cell.

• Hence, press ENTER to have the output.

• Afterward, use Fill Handle to AutoFill the rest of the cells in column E.

Read More: Combine Text in Excel (8 Suitable Ways)

2. Apply CONCATENATE Function to Concatenate with Space

You can perform a similar task using the CONCATENATE function in Excel. Just follow the steps mentioned below in order.

Steps:

• Input the following formula in a selected cell.

• Next, hit the ENTER button.

• Then, you can drag the AutoFill Handle to copy the formula for the rest cells in column E.

Read More: How to Combine Text from Two or More Cells into One Cell in Excel

Similar Readings

• How to Add a 1 in Front of Numbers in Excel (7 Easy Ways)
• Excel CONCATENATE Showing Formula Not Result (5 Solutions)
• How to Concatenate Multiple Cells in Excel (7 Easy Ways)
• Combine CONCATENATE & TRANSPOSE Functions in Excel
• How to Concatenate Formula and Text in Excel (4 Examples)

3. Employ TEXTJOIN Function to Concatenate with Space

When you have a large range of cells to join, using the Ampersand (&) symbol or the CONCATENATE function may be a bit troublesome. In these cases, you can use the TEXTJOIN function of Excel. Let’s follow the instructions below to learn!

Steps:

• First of all, pick a cell (i.e. E5) to have the concatanated with space data.
• Followingly, input the following formula in that cell.

• After that, press ENTER to have the output.

• Further, AutoFill the TEXTJOIN function to the rest of the cells in column E.

Read More: How to Concatenate Range in Excel (5 Useful Methods)

Conclusion

At the end of this article, I like to add that I have tried to explain 3 suitable ways on the topic of how to concatenate with space in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.

Further Readings

• Combine Multiple Columns into One Column in Excel
• How to Concatenate Two Columns In Excel (5 Methods)
• Combine Multiple Columns into One Column in Excel
• Opposite of Concatenate in Excel (4 Options)
• Concatenate Date and Time in Excel (4 Formulas)
• How to Combine Multiple Cells Into One Cell Separated By Comma In Excel (Functions & VBA)
• Concatenate Numbers in Excel (4 Quick Formulas)