Hello, I have quite the issue I am looking to resolve. I've been searching all over the internet now for at least 3 hours with no luck.



I have a word document with thousands of little areas with seemingly random messes of numbers, such as this:

I need to create VBA code that will allow me to take each of those little lists, expand those ranges (i.e., "39-41" would become separate entries of "39, 40, 41"), sort the list, then compress back into number ranges, where applicable.

Ideally I would just be able to select the numbers and fire the macro. I have found alphabetical sorting options, but I need numerical sorting.

Thanks in advance!!