I'm indexing a document with sections and sub-sections. I want to have one column representing the section-number and be able to sort by this column. However when the sub-section gets higher than 10, the sort no longer works.
This is the order I want...
1-1
1-2
1-10
2-1
Of course when we know this represents sections and sub-sections (or for example major and minor version numbers) that 1-10 is higher than 1-2, but of course both alphabetical and numerical sorting produces this order:
1-1
1-10
1-2
2-1
Is there a way to use numeric string sort (like -V
to sort
) in Google Sheets?