Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting 'legal' numbers
Have been sent a spreadsheet of various requirements. One column has
numbers in a legal type format i.e. 1.1.2, 1.2.3 up to 1.1.13. I need to sort these but of course 1.1.13 then gets put before the 1.2 Anyway of doing this? Many thanks, Shaun -- "Nothing in the world is more dangerous than sincere ignorance and conscientious stupidity." Martin Luther King, Jr. |
#2
|
|||
|
|||
Step one: save your data before using new functions, so you don't lose
anything! One way to do this is to insert some columns, then highlight your "legal" numbers column. On the menu at the top click Data Text To Columns and in the prompts that follow indicate the period as your delimiter. This function will separate each entry into its component numbers, so from there you can highlight the rows and perform a multi-column sort ("Sort by Column A, then by Column B, then by Column C"). Greetings from Virginia, USA, near Washington DC. |
#3
|
|||
|
|||
Dave O wrote:
Step one: save your data before using new functions, so you don't lose anything! One way to do this is to insert some columns, then highlight your "legal" numbers column. On the menu at the top click Data Text To Columns and in the prompts that follow indicate the period as your delimiter. This function will separate each entry into its component numbers, so from there you can highlight the rows and perform a multi-column sort ("Sort by Column A, then by Column B, then by Column C"). Greetings from Virginia, USA, near Washington DC. That worked great and saved me hours. I also learned a new function. Really do appreciate it. Shaun -- "Nothing in the world is more dangerous than sincere ignorance and conscientious stupidity." Martin Luther King, Jr. |
#4
|
|||
|
|||
Glad it worked out for you!
That worked great and saved me hours. I also learned a new function. Really do appreciate it. Shaun |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting hyphenated numbers | Excel Discussion (Misc queries) | |||
sorting the row by numbers | Excel Worksheet Functions | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Sorting numbers | New Users to Excel |