How To Add A Space In Excel

Click on the alignment tab and then open the horizontal drop down menu in the text alignment section.

How to add a space in excel. It doesn t count the cell as a number in that case though the cell type is general. Insert space between number and text with kutools for excel 1 type a space into the text box. And then you will see space is added before each number.

2 check the only add to option and select 1st character is number from the below drop down list. For example this formula will change b34c12g45 to b 34c12g45. See below table we have two columns and hello word is listed in column a a1 world in column b b1.

Please do as follows. Insert space between words by concatenate function. Enter this formula concatenate a2 b2 c2 into a blank cell besides your data e2 for instance see.

Click kutools text add text see screenshot. This formula can only add a space before the first number. Then drag the fill handle down to the cells that you want to contain this formula and the cells in the same row have.

Good in column a a2 evening in column b b2. In the formula b3 is the text string cell which you will add space between the text and number. Unfortunately there is no direct way for you to add spaces before the upper case letters in excel but you can create user defined function to solve this task.

For extra space between cell text and the left or right cell border click left indent or right indent. Activate your worksheet which contains the text strings you want to add spaces. Click the ok button.