Reply to Message
Handy
Thanks! A useful little tidbit for those who weren't aware of it.
Personally, I've been using text-to-columns for years to parse data I've exported from other programs - usually lists of full-path filenames. The fun part was when I finally broke down and upgraded from 2000 to 2010 and had to figure out where the feature was relocated in the ribbon bar
I'm surprised, however, that you didn't extend the lesson to include all the pages of the feature. Like where you can format the data, or choose to skip a column of data entirely, so you don't have to mess around deleting columns later.
Personally, I've been using text-to-columns for years to parse data I've exported from other programs - usually lists of full-path filenames. The fun part was when I finally broke down and upgraded from 2000 to 2010 and had to figure out where the feature was relocated in the ribbon bar
I'm surprised, however, that you didn't extend the lesson to include all the pages of the feature. Like where you can format the data, or choose to skip a column of data entirely, so you don't have to mess around deleting columns later.
Posted by awgiedawgie
24th Nov
