when I run text to columns on a text string in excel I find that everything I
paste after that is also seperated and even in a new window it is already
broke down. would be nice excpet I cannot create a macro to handle this task
as the cells don't stay in the same place. When I close this file and reopen
it...it reverst to the default.

You don't like the way excel tries to help???

If no, just run another
data|text to columns
choose delimited
but uncheck all the delimiters.

Then test it out.

DMDiamond wrote:

when I run text to columns on a text string in excel I find that everything I
paste after that is also seperated and even in a new window it is already
broke down. would be nice excpet I cannot create a macro to handle this task
as the cells don't stay in the same place. When I close this file and reopen
it...it reverst to the default.

--

Dave Peterson