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.
> 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.

Signature
Dave Peterson