Excel: How to Add Space Between Text in a Cell


Often you may want to add space between text in a specific location of a cell in Excel.

For example, you might want to add space between the letters and numbers in some Employee ID:

Fortunately this is easy to do in Excel and the following example shows how to do so.

Example: Add Space Between Text in Cell in Excel

Suppose we have the following column of Employee ID’s in Excel:

Suppose we would like to add a space between the letters and the numbers of each Employee ID.

To do so, we can type the following formula into cell B2:

=LEFT(A2, 3)&" "&MID(A2, 4, LEN(A2))

We can then click and drag this formula down to each remaining cell in column B:

Excel add space between text in cell

Column B now displays each Employee ID from column A with a space added between the first three letters and the remaining numbers in each cell.

How This Formula Works

Recall the formula that we used to add text between the letters and numbers in cell A2:

=LEFT(A2, 3)&" "&MID(A2, 4, LEN(A2))

Here is how this formula works:

First, we use the LEFT function to extract the first three characters from the left of cell A2. This returns AAR.

Next, we use the MID function with the LEN function to extract the characters in positions 4 through the last position of cell A2. This returns 3090.

We then use &” “& to concatenate a space in between these characters to end up with AAR 3090.

We repeat this same process for each Employee ID.

Note: If you would like to add spaces in multiple locations between text in a cell, then you can use the MID function multiple times to extract different pieces of text and concatenate a space in between each piece of text.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Remove Specific Text from Cells
Excel: How to Extract Text After Last Space
Excel: How to Find Last Space in a String
Excel: How to Insert a Character into a String

Featured Posts

Leave a Reply

Your email address will not be published. Required fields are marked *