I need more information
where do you want to add the data into excel?
Do you want each lint in the text file in a seperate row of the worksheet
all in column A? Then add the spaces to the cell?

Or do you wantt each set of 3 characters in a different column?

Be careful, there is a limit to the number of characters you can put in each
cell. I thinik its 256 characters.



"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