KatGamer Posted May 13, 2018 Share Posted May 13, 2018 (edited) I have a list of titles that looks like this: 10. Title 9. Another Title 8. Title Three 7. More Titles and so on. Except it's not just ten, it's hundreds. Is there a text editor that can simply reverse the list so that 1 is at the top instead of 10? Link to comment Share on other sites More sharing options...
0 zhangm Supervisor Posted May 13, 2018 Supervisor Share Posted May 13, 2018 If you can paste your list into Excel, then place it in Column A. In Column B, make a new ordered list, running 1, 2, 3, 4, 5, etc, with one number directly beside the items in your list that you want to reorder. Highlight both columns. Go to Data > Sort. In the menus, sort by B, descending order. This will also affect items in column A. Copy and paste the list from A back to where you need it to be. GSDragoon 1 Share Link to comment Share on other sites More sharing options...
0 KatGamer Posted May 13, 2018 Author Share Posted May 13, 2018 Is there a fast way in Excel or Google Sheets to auto-number a lot of cells? I don't really use spreadsheets much. Link to comment Share on other sites More sharing options...
0 zhangm Supervisor Posted May 13, 2018 Supervisor Share Posted May 13, 2018 5 minutes ago, KatGamer said: Is there a fast way in Excel or Google Sheets to auto-number a lot of cells? I don't really use spreadsheets much. In column B1, type 1. In column B2 type =B1+1, then press Enter. Click on B2 so that it is surrounded by the selection border. A small square should appear in the bottom right corner of the cell. Click and drag that square downwards until you get to the bottom of your list in column A. This will auto-fill the cells with B2+1, B3+1, B4+1...all the way down. KatGamer 1 Share Link to comment Share on other sites More sharing options...
0 ShadeOfBlue Posted May 13, 2018 Share Posted May 13, 2018 Or use Notepad++ Edit -> Line Operations -> Sort Lines as... (several ways to choose from) goretsky 1 Share Link to comment Share on other sites More sharing options...
0 KatGamer Posted May 13, 2018 Author Share Posted May 13, 2018 Just now, ShadeOfBlue said: Or use Notepad++ Edit -> Line Operations -> Sort Lines as... (several ways to choose from) THANK YOU that seems even easier!! +Zlip792 1 Share Link to comment Share on other sites More sharing options...
0 DevTech Posted May 13, 2018 Share Posted May 13, 2018 Notepad++ is a great editor but it is amazing how people like and dislike editors so fortunately there is a good selection of free editors! Any modern programming editor (well, the good ones will have it) will have scripting ability and a library of plug-ins... https://en.wikipedia.org/wiki/Source_code_editor https://en.wikipedia.org/wiki/Comparison_of_text_editors#Programming_features https://en.wikipedia.org/wiki/Comparison_of_integrated_development_environments Link to comment Share on other sites More sharing options...
Question
KatGamer
I have a list of titles that looks like this:
10. Title
9. Another Title
8. Title Three
7. More Titles
and so on.
Except it's not just ten, it's hundreds. Is there a text editor that can simply reverse the list so that 1 is at the top instead of 10?
Link to comment
Share on other sites
6 answers to this question
Recommended Posts