how do I format some text....."abc123" into "abc 123"

[gerry.lisa]

I just want to add a space ion the middle

Thanks!

....Lisa

 

[David Biddulph]

=LEFT(A1,3)&" "&RIGHT(A1,3)

 

[Pete_UK]

Try this, assuming your text is in A1:

=LEFT(A1,3)&" "&RIGHT(A1,3)

Copy down if required.

Hope this helps.

Pete

 

[gerry.lisa]

Thank you!!

....Lisa

=LEFT(A1,3)&" "&RIGHT(A1,3)