There are at least two ways to add spaces to excel text:

The most common method: click the "space" key in the middle of the text to add spaces.

Formula method: input formula = concatenate (left (a 1, 2)&; & mid (A 1, 3,2) and amp”& right (a 1,1))

Then, drop down and fill in the left or right side of all the cells to be filled with spaces, copy them and paste them in the required position in the form of "paste values" (see the following figure 1, 2, 3 for details):

Figure 1 Excel text plus space formula

Figure 2 Paste value

Figure 3 Effect after pasting the value

Note: The list formula is verified in Excel 2007.