Thread: how can I insert a space every three characters?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
  
Posts: 699
Default how can I insert a space every three characters?
I have a long string of data in a text document that I want to enter into an
Excel document. I also want to insert a space after every three characters.

For example, AGCTGCCAAGTC

gets changed to this : AGC TGC CAA GTC, and each of these triplets is in
separate columns

Reply With QuoteReply With Quote