Use of Excel sorting function

You can look at the above three columns of time data , Their format is different , The two columns on the left are “ Text ” Format （ To the left of the cell ）, The right column is numeric format （ Close to the right of the cell ）. We need to change the time on the left to numeric , Using the sorting function can complete .

1： Select the data range of remote processing .
2： Find the data bar .
3： Dissection .
4： Separator symbol .
5： next step .

1： Default choice .
2： next step .

1： routine （ Both numerical ）, That is, the tool mainly used .
2： complete .

View results （ Has been converted from text to numeric ）.

Here's a list of data （ More ）, Intermediate use - It's connected , How do we separate （ Of course, the replacement function can also be realized ） Come on .

1： Select the data range .
2： data .
3： Dissection .
4： next step .

1： other .
2： fill “-”.
3： next step , And you can view the preview .

View results , It has been divided into two columns , On the left is numeric , On the right is text .

There's a column of data , We are going to put # Get rid of , And ensure that the data is text （ Close to the left of the cell ）, You can also use the disaggregation tool .
1： Select data .
2： Data column .
3： Dissection .
4： next step .

1： Choose “ other ”.
2：#, You can view the preview .
3： next step .

1： To ensure that the data is entered in text , Select text .
2： And select the data column .
3： complete .

View results .