Organizing 1,2,3,4,6,7,8 etc to 1-4, 6-8

Try this. I haven't tested it exhaustively so the logic might not hold for all instances. This, however, demonstrates the principle.

Please Login or Register  to view this content.

Open the VBA editor by hitting Alt F11.
Insert a new module with Insert - Module
Paste in the above function
Go back to the sheet by hitting Alt F11.

In a cell B1, enter = Compress(A1)

Remember to save the workbook as a macro enabled workbook .xlsm