How to add blank space in Excel formula
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-add-blank-space-in-excel-formula-1.png)
Excel offers a very interesting way to add blank space in formulas. We can cater to this problem statement by using the “&” “&” operators. We can perform the below mentioned way to add blank space in excel formula:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook with a text formula
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-add-blank-space-in-excel-formula-1.png)
– Open the desired Excel workbook containing a text written in a formula
Step 2 – Using the operators
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-add-blank-space-in-excel-formula-1.png)
– Now click inside the formula where you want to add a blank space and type “&” “&”, and hit enter.
Step 3 – Blank space added
![](https://spreadcheaters.com/wp-content/uploads/Step-3-How-to-add-blank-space-in-excel-formula-1.png)
– We can see that now a blank space has been added between the words as shown in the image above.