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:

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