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

  • Thread starter Thread starter gerry.lisa
  • Start date Start date
Try this, assuming your text is in A1:

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

Copy down if required.

Hope this helps.

Pete
 
Back
Top