# 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.

### 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:
`=B5&" "&C5&" "&D5`

• Press ENTER to see the output.

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

### 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.
`=CONCATENATE(B5," ",C5," ",D5)`

• Hit the ENTERÂ button.

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

### 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:
`=TEXTJOIN(" ",TRUE,B5:D5)`

• Press ENTER to see the output.

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

Notes

Note: The TEXTJOIN function is only available in Office 365.

Get FREE Advanced Excel Exercises with Solutions!
Rifat Hassan

Rifat Hassan, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, has worked with the ExcelDemy project for almost 2 years. Within these 2 years, he has written over 250 articles. He has also conducted a few Boot Camp sessions on effective coding, especially Visual Basic for Applications (VBA). Currently, he is working as a Software Developer to develop and deploy additional add-ins to enhance the customers with a more sophisticated experience with Microsoft Office Suits,... Read Full Bio

1. Hi Rifat

Is it possible to TextJoin non-consecutive and out-of-order cells, EG A4:A6 plus A1?

Thanks // Dominic

2. Hi DOMINIC,
Yes, itâ€™s possible to join non-consecutive cells using the TEXTJOIN Function in Excel.
Let me show you how you can do it.
Letâ€™s assume this is your dataset.

Then, in A8, apply the following formula
`=TEXTJOIN(",",TRUE,A4:A6,A1)`

The delimiter is a comma (,)
TRUE indicates that you are going to ignore empty values.

Then, press ENTER to get the output.

I hope it helps.
Have a good day.

3. Hi Rifat,

Thank you for your easy-to-follow instructions that make life easy to use some of Microsoft Excel functions.

Advanced Excel Exercises with Solutions PDF