Sorting page-numbers with ranges (i.e.: 6ff or 7-10 etc.)
Hi,
I have a excel-file with rows of unsorted page-numbers from a book.
After I select a couple of rows I would like to sort them.
Problem is: there are page-ranges like "14f" or "17ff" or "1141-1432". The excel build-in function cannot do this. I would think this requires VBA, but I cant do it myself.
I have attached two screenshots: first is the unsorted input, second is the desired output.
I have attached a excel-file, too. Desired output is in Worksheet 2. Please note, that the output should be in fact in worksheet 1 (i.e. output should replace the unsorted input), not in worksheet 2.
Thank you very much in advance for your help!
|