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
sort) in Google Sheets?