Text Tools
Cleaning, fixing, filtering, and diffing text.
How to Remove Duplicates from a List Online
Remove duplicate lines from any list in seconds. Paste your list, check one box, copy the result. Works for names, emails, IDs, or any line-separated data.
Read article →
How to Compare Text Online
See exactly what changed between two blocks of text. Additions and removals highlighted line by line. Works in your browser, no software needed.
Read article →
How to Clean Up a List Online
Fix messy list data in one pass: trim whitespace, replace null values, standardise dates, strip currency symbols, and remove blank lines.
Read article →
Why Two Identical-Looking Lines Won't Match
Two cells or lines look exactly the same but a comparison, VLOOKUP, or filter says they don't match. Here's every likely cause and how to fix each one.
Read article →
How to Filter a List by Text, Pattern, or Length
Keep or remove lines that contain specific text, match a pattern like an email or URL, or fall outside a length range - no regex required.
Read article →
How to Find and Replace Text in a List Online
Substitute text across an entire list at once - literal text, whole-word matches, or regex with capture groups - and chain multiple replacements in sequence.
Read article →
How to Sort a List of Numbers Correctly (Not Alphabetically)
1, 10, 100, 2 instead of 1, 2, 10, 100 - the classic text-vs-number sort bug. Here's why it happens and how to sort a pasted list numerically without Text to Columns.
Read article →
How to Remove Currency Symbols from a List of Prices
Strip $, €, £, and other currency symbols from a pasted list of prices in one pass, along with thousands separators and inconsistent decimal formats - no Find & Replace needed.
Read article →
How to Clean Up a List Copied from a PDF
Doubled spaces, split rows, and stray page numbers - the specific mess PDF tables leave behind when pasted as a list, and how to fix each one without retyping.
Read article →
How to Delete Everything Before or After a Specific Character in a List
Strip everything before or after a comma, colon, or any marker from every line of a list at once, with or without keeping the marker itself - no TEXTBEFORE formula needed.
Read article →
How to Find Invisible Characters in Text
Non-breaking spaces, zero-width characters, and stray tabs make text that looks identical fail to match. Reveal every hidden character and get a cleaned copy.
Read article →
How to Add Text to the Beginning or End of Every Line
Add a prefix or suffix to every line of a list at once - wrap in quotes, add a URL prefix, prepend an @ symbol - without a formula or per-line find-and-replace.
Read article →
Excel's Remove Duplicates Not Working? Here's Why
Rows that look identical but survive Remove Duplicates usually have a hidden difference: trailing spaces, non-breaking spaces, or text-formatted numbers.
Read article →
How to Standardize Date Formats in a List
Mixed date formats from merged exports break sorting and matching. Here's why the mix happens, why ISO 8601 is the safe target, and how to fix it in one pass.
Read article →
How to Compare Two Files in Notepad++
How to install and use the Compare plugin in Notepad++, read the color-coded output, its limitations, and a no-install alternative for comparing text on any OS.
Read article →
How to Compare Two Files in VS Code
Compare two files in VS Code using Explorer selection, the command palette, or a diff against the clipboard, plus diff editor navigation and a browser alternative.
Read article →
Compare Two Text Files Online (No Install Needed)
Compare two text files in your browser - no software to install, no upload to a server. Drag-drop files, pick side-by-side or unified view, download the diff.
Read article →
How to Compare Two Word Documents for Differences
Word's built-in Compare feature step by step, its Word Online limitation, and a quick paste-based alternative for checking text differences without Word.
Read article →
How to Compare Two JSON Files (and Actually See the Differences)
Raw JSON diffs look worse than they are due to key order and formatting. Normalize with json.tool or jq -S, then diff - the reliable recipe plus gotchas.
Read article →
How to Read a Unified Diff (---, +++, @@ Explained)
Decode the unified diff format used by git, diff, and patch - what --- and +++ mean, how to read @@ hunk headers, and what the +/- line prefixes mean.
Read article →
How to Alphabetize a List Online
Alphabetize any list online in seconds. Paste your list, choose A-Z or Z-A, and copy the result. Handles mixed-case text and duplicates automatically.
Read article →
How to Remove Blank Lines from a List
Remove every blank line from a list instantly. Paste your text into Text Fixer and blank lines are stripped automatically - no formula or macro needed.
Read article →
How to Add Quotes Around Each Line in a List
Wrap every line of a list in single quotes, double quotes, or backticks in one paste. Built for SQL IN clauses, code arrays, and quoted CSV values.
Read article →
How to Lowercase a List Online
Convert an entire list to lowercase in one paste. Also supports UPPERCASE and Capitalize Each Word, for normalizing emails, tags, or usernames.
Read article →
How to Remove Line Breaks from a List
Turn a multi-line list into a single line of text. Paste your list and every line break is replaced with your chosen separator, or removed entirely.
Read article →