This makes life much easier, when writing long formulae! There’s one gotcha – Notepad++ by default uses tabs rather than spaces, which breaks Excel.
Some things to mention about this formula: Then whenever you need to resort, go to Data > Sort. If you like, you can hide that column, so you don’t need to look at its hideousness. You end up with this, on which you can now perform an alphabetical (A-Z) sort: If you're going to do this more often you could record a macro with these steps.And then in any of the rows in that column, we enter this formula: = If you need longer numbers just add more zeros to the first replacement, and increase the 10 in the second replacement accordingly.
Once sorted the last expression will strip all leading zeros so you'll have your original numbers back. Those will sort in the order you want them to sort. The second replacement than takes the last 10 digits of the number to bring everything back to the same length, giving you numbers like 0000000839, 0000000003 etc. It works by adding 10 zeros before the number, even though that's probably too much. These are the steps (works for number up to 10 characters) Then they will sort correctly and you can use another replacement to strip the leading spaces/zeros afterwards. I don't know what your file looks like, but I'd use regular expressions to add spaces or zeros before each number to make them the same length (e.g. (Note if you don't select any text it will sort the entire file, and if you select text it constrains the sorting to the selected text.) This is now easy to achieve (at least in Notepad++ 7.5.9):Įdit -> Line Operations -> Sort Lines As Integers Ascending
0 kommentar(er)
