Table of Contents
Excel is an extremely powerful and versatile tool for data analysis and manipulation. Its ability to organize and manipulate data quickly and easily makes it the ideal tool for a variety of tasks, including data analysis and reporting. One of the most useful features of Excel is its ability to allow users to add space between text in a cell. This can be extremely helpful when organizing data, as it makes it easier to read and interpret. In this article, we will discuss the importance of adding space between text in a cell and how to do it in Excel.
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:
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.