根据内容最后一位进行排序

1.  Select a blank cell besides the column, says Cell B2, enter the formula of =RIGHT(A2,1), and then drag the cells's Fill Handle down to the cells as you need.

2. Keep selecting these formula cells, and click Data > Sort A to Z or Sort Z to A. In the opening Sort warning dialog box, check Expand the selection option and click Sort button. See screenshot:

posted @ 2019-06-28 17:01  kakaisgood  阅读(201)  评论(0)  编辑  收藏  举报