To sort text numbers in Excel, paste the copied values into Text Sorter, enable its Natural number order option, and sort up to 50,000 logical lines. This workflow is designed for cells that contain digit strings, including values with leading zeros, even when Excel treats them as text rather than quantities. Instead of asking Excel to infer a mixed data type, you isolate one column, sort its plain-text lines with number-aware comparison, and return the ordered values to the worksheet. Natural number order makes digit runs compare numerically while preserving each retained line’s character content unless trimming is explicitly selected. The same route works for numbered labels, filenames, inventory codes, and test data that should remain strings. You can also enable trimming, empty-line removal, or exact-duplicate removal, with each cleanup control changing the data explicitly. Text Sorter processes the paste locally, renders the complete result for review, and produces a UTF-8 TXT download when you are ready. The preview also shows the original and final logical line counts, making cleanup changes visible before the sorted values go back into Excel.
Why text-formatted Excel numbers need explicit ordering
Excel’s sort result can depend on the stored cell type and the active spreadsheet rules. When numeric-looking cells are treated as text, Excel compares their characters as labels instead of comparing their digits as quantities. A character-based order can therefore place 10 before 2 even though the intended sequence is numerical.
Consider values named item2 and item10. With Natural number order enabled, item2 comes before item10 because their digit runs are compared numerically. The sorter does not convert either line into a spreadsheet number. It changes their order while leaving the text of each retained line intact unless trimming is selected, so leading zeros and other characters remain present in the TXT result.
This distinction matters when the goal is display order rather than arithmetic. The workflow is suitable for word lists, filenames, labels, simple inventory values, test data, copied table columns, and line-oriented notes. If the final goal is to calculate with the values in Excel, sorting alone will not change their cell type; that requires a separate text-to-number conversion.
Sort a copied Excel column with Text Sorter
-
Copy one Excel column. Select the values you want to reorder and copy them from a single column. Remove a header if it should not be included in the sort. Keep adjacent columns out of this workflow because Text Sorter treats each complete pasted line as one sortable item rather than parsing a multi-column table.
-
Paste the values into the input box. Each Excel row should become one logical line. The accepted paste is limited to 1,000,000 UTF-16 code units and 50,000 logical lines, so both limits must be satisfied. Blank rows also count as logical lines until the relevant cleanup control removes them.
-
Choose the direction. Select ascending order to apply the comparison from lower to higher, or descending order to reverse the comparison result. Check the original data first if you need a particular direction.
-
Set the comparison rules. Enable Natural number order for digit strings that should follow numeric sequence. Decide separately whether comparison should be case-sensitive. With case sensitivity off, letters that differ only by case compare as equivalent for ordering; with it on, case participates in the collation.
-
Enable only the cleanup controls you need. The cleanup sequence is fixed. Trimming runs first and removes leading and trailing Unicode whitespace without collapsing spaces inside a line. Empty-line removal runs next, so a whitespace-only line becomes empty and is removed only when trimming and empty-line removal are both enabled. Exact-duplicate removal follows, keeping the first occurrence of each exact string.
-
Sort the lines. Run the sort operation using the direction, comparison, and cleanup settings you selected. Sorting itself changes line order, not the number of lines.
-
Verify the counts and preview. Compare the original logical line count with the final line count, then inspect the complete preview for the expected order and any cleanup effects. A count difference comes from empty-line or exact-duplicate removal, not from sorting itself.
-
Download the TXT result. After verification, download the sorted text as a UTF-8 file. The output contains the complete result rather than only the visible portion of the preview.
-
Return the values to Excel. Open the downloaded TXT file in a plain-text editor, copy its contents, and paste them into the first cell of an empty target column. If leading zeros must be preserved as Excel text, format the target column as Text before pasting. Keep the original column unchanged until you have checked the imported values.
Set the comparison and cleanup rules
Each option controls a different part of the operation. Cleanup controls can be enabled independently, but they run in a documented order before the lines are sorted.
| Control | Choice | What it changes |
|---|---|---|
| Direction | Ascending or descending | Ascending compares from lower to higher; descending reverses that comparison while preserving the original order of equivalent lines. |
| Case sensitivity | On or off | When off, text differing only by case compares as equivalent. When on, case participates in the ordering. |
| Natural number order | On or off | When on, digit runs compare numerically. When off, the same values are compared as ordinary text. |
| Trim every line | On or off | Removes leading and trailing Unicode whitespace without collapsing whitespace inside the line. |
| Remove empty lines | On or off | Removes lines that are empty after the optional trimming step. |
| Remove exact duplicates | On or off | Keeps the first exact string and removes later copies. Exact matching uses JavaScript string equality, so capitalization differences remain distinct. |
Text Sorter uses the browser’s English Intl.Collator for comparison. This is linguistic English collation rather than a raw Unicode code-point or byte sort. Equivalent lines retain their original relative order because the sort is stable. Descending order also preserves stability for equal values; it does not simply reverse an already sorted array.
Natural number order should not be mistaken for a general structured-data parser. It does not interpret decimal quantities, dates, versions, units, or signed mathematical expressions as specialized data types. Use it for digit runs embedded in otherwise comparable strings, and leave it off when the list should follow ordinary text order.
Check counts and the exact preview
The result panel reports both the original logical line count and the final line count. Sorting never accounts for a difference between them. A lower final count means that the empty-line or exact-duplicate control removed content, so compare the preview with your original list before downloading.
The entire accepted result is rendered for review. Visual wrapping in the preview does not create additional logical lines. If you edit the paste or change any option, the previous output is cleared immediately, preventing a line count from one configuration being mistaken for the result of another.
Text Sorter recognizes CRLF, standalone CR, and LF as line boundaries. Mixed input endings are normalized to LF in the downloaded output, while the text of each retained line stays unchanged unless trimming was explicitly enabled. This makes the result predictable when the file will be processed by another plain-text tool.
Know when the text workflow is the wrong format
Text Sorter is deliberately line-oriented, not spreadsheet-aware. It accepts nonempty, valid input only within both the 1,000,000-code-unit and 50,000-line limits. An over-limit paste is rejected before sorting begins, and no partial output is returned.
Do not paste an entire CSV file or a multi-column Excel table when record structure matters. A CSV row can contain a quoted line break, so sorting physical lines may break the record. Text Sorter does not understand quoting, headers, or column relationships. A format-aware table tool is the safer choice when those features are important. Likewise, if the sorted values must stay aligned with several Excel columns, prepare and sort one explicit key column rather than treating whole spreadsheet rows as independent lines.
Collation can also differ from database ORDER BY behavior, operating-system filename ordering, spreadsheet locale settings, or another programming language. If the result will become a contractual or reproducible machine artifact, confirm that the destination system uses compatible English collation and the same numeric and case settings.
For repeated use, the same accepted text, browser collation implementation, and options produce the same line sequence. Cleanup, sorting, previewing, and download creation happen locally; nothing is uploaded to Lizely. This makes the workflow suitable for sensitive lists as well as routine spreadsheet cleanup, provided the input really is a collection of independent text lines.