I'll try and explain:
I've got a list of filenames in one column in an Excel sheet (about 200 or so), and I want to sort this column (data/sort command) using the same character order as Windows explorer.
One problem though - I don't know what order that explorer uses to sort the data, I just...
Is it possible to sort Excel data in the same way as Windows Explorer? I realise that Excel has it's own sort rules, but can these be modified in any way (other than just by checking different day or date options)?