Feature catalog

Remove stray spaces or tabs at the start or end so text is clean and consistent.

“ Hello World ” → “Hello World”

Turn any run of spaces/tabs into a single space. Great for messy pastes.

“A B C” → “A B C”

Unifies Windows/Mac/Unix line endings so downstream steps behave the same.

“Line1\r\nLine2” → “Line1\nLine2”

Strips invisible ZWSP/ZWNJ/ZWJ/BOM that break matching and sorting.

“user​name” → “username”

Canonicalize text (NFC/NFKC) so visually identical strings compare equal.

“é” (e+´) → “é”

Convert curly quotes and em/en dashes to plain quotes and hyphens.

““It’s—fine” → "It's-fine"”

Change the single character … into three dots for consistency.

“Wait… please” → “Wait... please”

Convert ＡＢＣ１２３ to ABC123 (or the reverse) for CJK/typography use-cases.

“Ｈｅｌｌｏ １２３” → “Hello 123”

Remove accents/combining marks to get ASCII-friendly text.

“Clichés & Résumés” → “Cliches & Resumes”

Shrink repeated punctuation runs to a single character.

“what???!!!” → “what?!”

One-click case fixes for headings, sentences, and catalog data.

“tHE quICK bROWN FOX” → “The Quick Brown Fox”

Keeps minor words like “and/of/the” lowercase unless first or last.

“war of the worlds” → “War of the Worlds”

Edit which words stay lowercase in titles to match your style guide.

Add “vs” or “via” to the list.

Leaves acronyms (API, NASA) untouched when changing case.

“api gateway” → “API Gateway”

Single space after punctuation and tidy spaces around commas/colons.

“Hello , world !” → “Hello, world!”

Collapse accidental repeats like “the the”.

“the the quick fox” → “the quick fox”

Alphabetize and/or dedupe tokens inside a cell.

“pear, apple, pear” → “apple, pear”

Swap any exact text with something else. Optional case/whole-word match.

“St.” → “Street”

Powerful pattern matching with capture groups for complex fixes.

“03/09/2025” with `(\d{2})/(\d{2})/(\d{4})` → “2025-09-03”

Run a reusable set of key→value replacements (import/export CSV).

“Rd”→“Road”, “Ave”→“Avenue”, “St”→“Street”

Add fixed text before the current value—great for IDs and tags.

“1234” + Prefix “INV-” → “INV-1234”

Add fixed text after the value.

“Report” + Suffix “.pdf” → “Report.pdf”

Avoid adding prefixes/suffixes to blank cells.

Empty cell stays empty.

Add numbers as a prefix, suffix, both, or insert at a position.

“Alpha” → “001-Alpha”

Control the starting number, increment, and zero-padding.

Start 5, step 5, pad 3 → “005, 010, 015 …”

Choose digits, letters (A, B, C), or Roman numerals.

“A, B, C” or “I, II, III”

Restart numbering within groups (e.g., per client or category).

Client A: 001–…, Client B: 001–…

Use templates like “File-{num}” for total control.

“File-007”

Remove spaces, tabs, line breaks, non-breaking spaces, or zero-widths.

“Hello\tWorld\n” → “HelloWorld” (if all selected)

Strip all letters, only uppercase/lowercase, or digits as needed.

“ABc123” → “123” (keep digits only)

Remove punctuation, brackets/quotes, or symbol classes.

“(Hello) #1!” → “Hello 1”

Remove diacritics while keeping the base letters.

“São Paulo” → “Sao Paulo”

Remove emojis or any character outside basic ASCII.

“Party 🎉 at 7pm” → “Party at 7pm”

Delete a specific set of characters—or use regex for advanced rules.

Remove `_-.` → “my_file-name” → “myfilename”

Remove anything in (), [] or {}—handy for notes and versions.

“Report Q1 (draft v3)” → “Report Q1”

Split by comma/pipe/space—or advanced patterns using regex.

“a, b , c” (regex `\s*,\s*`) → ["a","b","c"]

Respect quoted commas when splitting CSV-like strings.

"Doe, Jane", Sydney → ["Doe, Jane","Sydney"]

Grab the Nth token, a range, or drop unwanted parts.

“name@domain.com” split by “@” → keep 2 → “domain.com”

Trim, drop empties, dedupe, and sort (natural A→Z).

“pear, apple, pear” → “apple, pear”

Write back the result as a JSON array in the same cell.

["alpha","beta","gamma"]

Join tokens with commas or line breaks for human-readable lists.

“a, b, c” → “a\nb\nc”

Reorder tokens with placeholders like {1}, {2}, {3}.

“Last, First, Dept” → “First Last — Dept”

Lowercase, clean, and hyphenate text for SEO-friendly slugs.

“Clichés & Résumés” → “cliches-resumes”

Convert accents to plain ASCII so slugs work everywhere.

“Málaga” → “malaga”

Remove or replace characters that break on Windows/macOS.

“My:Report*.pdf” → “My_Report.pdf”

Keep file extensions intact and clamp filename length safely.

“Very long… .mp4” → “Very-long… .mp4”

Pull the first, last, or all numbers (incl. negatives/decimals).

“Size: 12.5kg (was 15)” → “12.5”

Find emails and optionally keep only the domain part.

“jane@acme.com” → “acme.com”

Grab URLs, strip tracking params, and normalize the scheme.

“…?utm_source=x&id=5” → “…?id=5”

Validate and format phone numbers for a region (e.g., AU).

“(02) 9999 0000” → “+61 2 9999 0000”

Make text safe for URLs (or bring it back to readable text).

“Hello World” → “Hello%20World”

Encode/decode & < > quotes and more.

“A & B” → “A & B”

Encode or decode Base64 for text payloads.

“Hello” → “SGVsbG8=”

Escape strings so they’re safe inside JSON quotes.

“Line1\nLine2” → “Line1\\nLine2”