How to add a space in Excel formula.

Excel is a powerful tool for data analysis and manipulation, and it is widely used in businesses, organizations, and individuals. One of the common tasks in Excel is to concatenate (join) text strings or cell values. Sometimes, you may want to Add a Space between the text strings or cell references.

Here we have a dataset, in this dataset, we have 2 columns both containing data that we need to Add together but need a space between them. In this tutorial, we will learn how to add a space in the Excel formula but first, let’s take a look at the Dataset above.

Method – 1 Using the Concatenate formula.

Step – 1 Select the cell.

• Select the cell where you want to write the formula.
• The syntax of the formula will be

=CONCATENATE(First_Cell_Address,” “,Second_Cell_Address)

• In our case the formula will be

=CONCATENATE(A1,” “,B1)

Step – 2 Finding values of the rest of the cells.

• Click on the cell with the formula.
• Drag from the bottom right down to the rest of the cells.
• The formula will be applied automatically.

Method – 2 Using Ampersand operator to add space in formula.

Step – 1 Selecting the cells.

• Select the cell where you want to write the formula.
• The syntax of the formula will be

=Fisrt_Cell_Address&” “&Second_Cell_Address

• In our case the formula will be

=A2&” “&B2

Step – 2 Find the values of the rest of the cells.

• Select the cell with the formula.
• Drag from the bottom right to the rest of the cells.
• The formula will be applied automatically.

Method – 3 Using the TEXTJOIN formula.

Step – 1 Select the cell.

• Select the cell where you want to write the formula.
• The syntax of the formula will be

=TEXTJOIN(” “,TRUE,First_Cell_Address,Second_Cell_Address)

• In our case the formula will be

=TEXTJOIN(” “,TRUE,A2,B2)

Step – 2 Finding values of the rest of the cells.

• Click on the cell with the formula.
• Drag from the bottom right down to the rest of the cells.
• The formula will be applied automatically.