About Us

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Return cell characters after space	Andy	Excel Worksheet Functions	3	April 30th 23 12:22 PM
Trim Characters Other Than An Empty Space At The End Of A Cell	K8_Dog	Excel Worksheet Functions	5	April 19th 08 01:29 AM
Put A Space Between 2 right characters	carl	Excel Worksheet Functions	3	April 8th 08 05:08 PM
Count Characters with space in a cell	NH	Excel Discussion (Misc queries)	5	April 5th 07 05:07 AM
cHARACTERS BEFORE THE SPACE	T De Villiers	Excel Worksheet Functions	3	January 19th 06 01:22 AM

Menu

About Us