Thread: how do I format some text....."abc123" into "abc 123"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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



Reply With QuoteReply With Quote