I've been using "Data > Text to Columns" for years...

Such a simple little thing, but it will save some time.

Mark Hickin: I like the EM/QA copy & paste trick; haven't seen that before.  Not that I'd use it much but handy to know nonetheless.