Hi Sandy,
When you use Text to Columns, the last stage gives you (among other things)
the option of exactly where you want the expanded the to go. This is the
Destination Feild. Excel defaults this to the source cell, so if you don't
change it, it will over-write the original data.
Just make sure you change this to some other cell. This way, you can put
your expanded data wherever you like, and your original data will not be lost.
Regards - Dave.