Inserting a Space in The Same Place Formula

[Guest]

I have a column of data that comes in like so :

ABCAA
EFGDD
HIJSS

I would like a formula in COLB that will but a space in between the 3rd and
4th characters.

ABC AA
EFG DD
HIJ SS

I've been using the text to columns function but was hoping that a folrmula
could do they same thing.

Thank you in advance.

 

[Jason Morin]

=REPLACE(A1,4,," ")

HTH
Jason
Atlanta, GA

 

[Myrna Larson]

=LEFT(A1,3)&" "&MID(A1,4,2)