I had to really dig to figure out where I'd seen this little discussion but I want to say thanks a million for bringing up this question. I use Excel all the time but for very routine stuff. I didn't even realize you could do this. Anyway I had this really messy worksheet that had been copied from another source and I thought this would help me get data in one cell (a number and a name) into two separate cells. I called up the little paper clip guy and with just a couple of false starts I found the Text to Columns thingie. I couldn't use it for all the data but it really helped cut down the manual editing I had to do. And now I feel so smart.
