=LEFT(A1,3)&" "&MID(A1,4,2)
On Fri, 4 Mar 2005 10:25:05 -0800, "carl"
wrote:
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.
|