How to Concatenate with space in Microsoft Excel
In this tutorial we will learn how to concatenate the text in Microsoft Excel by using the concat function.
This function allows us to concatenate different text strings in one textbox. We can add space using “ ” between two texts. Normally texts are joined without spaces.
Below is the step to follow.
Microsoft Excel is a very powerful calculation tool for numeric data. In some cases we have to join different kinds of data placed in different cells rather than copy-pasting and adjusting the height and width of the cell. Microsoft Excel provides us with a built-in tool for it.
Step 1 – Select the cell and apply the formula
Above is an animation as an example.
– Select the text box in which you wish to join data from two different cells.
– Type the formula. (Add special characters if required).
– Select the cells to join from your data range.
– As long as you press the enter key it will join different text boxes in one textbox with space .
Hence, we have concatenated two texts with space as shown above.