S
sunxiangqian
My god, I have some excel file, the data sheets have so many columns,
and I need order like following,
1.1.1
1.1.1.2
1.1.2.1
1.1.3
1.1.4.2.3
1.2.5
1.10.6
1.11.1
How ever, using the excel order function, it looks like
1.1.1
1.1.1.2
1.1.2.1
1.1.3
1.1.4.2.3
1.10.6
1.11.1
1.2.5
The 1.2.5 shell before 1.10.6, how can I do it?
Thanks for help.
and I need order like following,
1.1.1
1.1.1.2
1.1.2.1
1.1.3
1.1.4.2.3
1.2.5
1.10.6
1.11.1
How ever, using the excel order function, it looks like
1.1.1
1.1.1.2
1.1.2.1
1.1.3
1.1.4.2.3
1.10.6
1.11.1
1.2.5
The 1.2.5 shell before 1.10.6, how can I do it?
Thanks for help.