How to enter space in Excel

Excel offers a very interesting way to enter space. We can cater to this problem statement by using the “&” “&” operators. We can perform the below mentioned way to enter space in excel:

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

– Open the desired Excel workbook containing a text written in a formula

Step 2 – Using the operators

– Now click inside the formula where you want to add a blank space and type “&” “&”, and hit enter.

Step 3 – Space added

– We can see that now a space has been added between the words as shown in the image above.