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

I just want to add a space ion the middle

Thanks!

....Lisa

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

=LEFT(A1,3)&" "&RIGHT(A1,3)
--
David Biddulph

wrote in message
oups.com...
I just want to add a space ion the middle

Thanks!

...Lisa

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

Try this, assuming your text is in A1:

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

Copy down if required.

Hope this helps.

Pete

On Aug 8, 12:04 am, "
wrote:
I just want to add a space ion the middle

Thanks!

...Lisa

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

Thank you!!

....Lisa

On Aug 7, 7:08 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
=LEFT(A1,3)&" "&RIGHT(A1,3)
--
David Biddulph

wrote in message

oups.com...

I just want to add a space ion the middle

Thanks!

...Lisa