Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
70
Excel Sorting Values With Multiple Decimals
posted

I was wondering if there was a way to read and sort a worksheet with a key column that is formatted in the form of:

1.1

1.1.1

1.2

1.2.1

1.2.1.1

1.10.1.1

Where e.g. 1.10.1.1 should be after 1.2 in the sort order, as normally it would take it as text and put it before 1.2.

Due to constraints, I'm not able to edit the Excel file itself so I was thinking either write it to a DataTable and manipulate it there or any other ideas would be appreciated. I need to format the data so that it's sorted and be able to extract the level order from the decimals.