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!

Attached Images

	Input unsort.jpg (20.0 KB, 26 views)
	output sorted.jpg (17.0 KB, 24 views)

Attached Files

Example Sorting.xlsm (10.6 KB, 11 views)