bring in your data. Select the single column and do Data=Text to columns

Select fixed and in the next page of the dialog, click between every 3rd and
4th character.

then continue on.

Turn on the macro recorder before you do this if you want code.

--
Regards,
Tom Ogilvy


"Sam" wrote:

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