[請問] excel 如何從右邊排序?
請問,我想把以下資料(中英文都在同一欄,不是兩欄):
abcde 愛吃紅蘿蔔(欄A1)
gazwsx 住台北 (欄A2)
slmokn 小兔子 (欄A3)
從右邊排序,變成:
slmokn 小兔子 (欄A1)
gazwsx 住台北 (欄A2)
abcde 愛吃紅蘿蔔(欄A3)
請問高手,函數該怎麼寫?感謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 27.242.229.78
※ 文章網址: https://www.ptt.cc/bbs/ask/M.1475682336.A.ACA.html
推
10/05 23:48, , 1F
10/05 23:48, 1F
→
10/05 23:48, , 2F
10/05 23:48, 2F
→
10/05 23:51, , 3F
10/05 23:51, 3F
→
10/05 23:52, , 4F
10/05 23:52, 4F
推
10/06 00:05, , 5F
10/06 00:05, 5F
→
10/06 00:09, , 6F
10/06 00:09, 6F
※ 編輯: brightbeach (27.242.229.78), 10/06/2016 00:12:10
推
10/06 00:13, , 7F
10/06 00:13, 7F
→
10/06 00:19, , 8F
10/06 00:19, 8F
→
10/06 00:19, , 9F
10/06 00:19, 9F
→
10/06 00:49, , 10F
10/06 00:49, 10F
→
10/06 01:09, , 11F
10/06 01:09, 11F