Arranging a list from A to Z is alphabetical ordering. This guide covers line ordering in SimpleText, Microsoft Word, Excel, and Google Sheets. It also explains why plain text ordering puts "item10" before "item2", a surprise if you expect numerical order. You will learn how to avoid traps like uppercase letters and leading spaces.
Ordering Lines in SimpleText
Using the Sort and Dedupe Tool
SimpleText includes a Sort and Dedupe tool for lists. Paste or type your list into the notepad, then click the Sort and Dedupe button. The tool arranges the lines alphabetically and removes duplicate lines. For a plain reorder that does not remove duplicates, run the Trim tool first to tidy stray spaces and blank lines, then sort.
Other Useful Tools
SimpleText also has live word, character, and line counts. UPPERCASE, lowercase, Title Case, and Sentence case converters sit alongside a Join lines option to collapse text into one paragraph. Text is saved in your browser’s local storage and never uploaded.
Why 10 Comes Before 2 in Plain Text Ordering
Plain text ordering compares characters one at a time. The character "1" has a lower code point than "2", so any line starting with "1" sorts before any line starting with "2". That means "item10" sorts before "item2" because the first differing character is "1" versus "2". This is called alphabetical ordering or dictionary ordering.
Natural Sort vs Alphabetical Sort
A natural sort treats numbers as whole values, so "item2" would come before "item10". But plain text tools like SimpleText use alphabetical sort unless they include a natural sort option. SimpleText uses plain character order.
How to Fix Number Ordering
To make plain ordering match numeric order, pad numbers with leading zeros. Write "item01", "item02", ... "item10". Then "01" sorts before "02" and "02" before "10". This works because the characters compare in the same order as the numeric values when all numbers have the same length.
Capital Letters and Spaces Throw Off Your Sort
In pure code-point (ASCII) order, all uppercase letters come before lowercase letters. "Apple" sorts before "apple". "Zebra" sorts before "apple". This can scramble a list if you expect case to be ignored. To get a case-insensitive sort, convert all lines to the same case before ordering. SimpleText has UPPERCASE and lowercase converters for this.
Leading spaces also sort before letters. A line starting with a space will appear before any line that starts with a letter. Run the Trim tool in SimpleText. It removes leading spaces and blank lines, giving cleaner sort results.
Ordering Paragraphs in Microsoft Word
In Microsoft Word, you can sort paragraphs alphabetically. Select the list, then go to Home > Sort (the A-Z button). Word’s Sort dialog lets you sort by paragraphs, text, and ascending or descending order. Word’s sort is a plain text sort by default, so the same rules for numbers, capitals, and spaces apply. For numeric lists, pad with zeros or sort manually.
Ordering Data in Excel and Google Sheets
Excel and Google Sheets treat data in cells and have dedicated sort commands. In Excel, select your range, go to the Data menu, and choose Sort A to Z. In Google Sheets, select the range, then Data > Sort range > Sort A to Z. Both tools offer options to sort by column and to treat numbers as numbers. They use a natural sort for numeric values, so "2" comes before "10" automatically. If your data includes text like "item2" and "item10", the sort still uses plain text order unless you split the text from the number.
Practical Steps for a Clean Sort
- Trim leading spaces and blank lines. In SimpleText, use the Trim tool. In Word, use Find and Replace to remove extra spaces. In Excel or Sheets, use the TRIM function.
- Normalize case. Convert all lines to the same case (lowercase) to avoid uppercase letters sorting before lowercase. SimpleText has a lowercase converter.
- Pad numbers with leading zeros. If your list has numbers that should sort numerically, add zeros so all numbers have the same width. Change "2" to "02".
- Sort the list. Use the Sort and Dedupe tool in SimpleText, the Sort button in Word, or the Data menu in Excel or Google Sheets.
- Review the result. Check boundary items like "10" and "2" to confirm the order meets your needs.