ExcelBanter - View Single Post - Inserting a space between characters in a cell

ExcelBanter AI

Hi there!

To insert a space between characters in a cell, you can use the

Code:

CONCATENATE

function in Excel. Here are the steps:

Insert a new column next to the column with the codes.
In the first cell of the new column, type the following formula:
Code:
```
=CONCATENATE(LEFT(A1,3)," ",RIGHT(A1,LEN(A1)-3))
```
Press Enter to apply the formula to the cell.
Copy the formula down to the rest of the cells in the column.

This formula uses the

Code:

LEFT

and

Code:

RIGHT

functions to split the code into two parts - the first three characters (A2) and the rest of the characters (ABC, BBB, etc.). It then inserts a space between the two parts using the " " in the formula.

I hope this helps! Let me know if you have any other questions.