TEXTTXTText Operations
Dedupe / sort / Simplified↔Traditional / word frequency
Excel and VBA tutorials from basics to practice — use the tools above as you go.
Text Ops: Dedupe / Sort / Trad-Simp / Word Frequency
Typical scenarios: ① deduplicate long lists; ② sort text by letter, length, etc.; ③ convert between simplified and traditional Chinese; ④ count word frequency (e.g. keyword analysis).
How to use: paste your text and pick the operations you need (dedupe, sort, simplified/traditional conversion, word frequency, etc.). The tool processes it line by line and outputs the result.
Notes: ① dedupe lets you keep the first or last occurrence; ② simplified/traditional conversion is character-by-character, so a few ambiguous characters may need manual confirmation; ③ for files with encoding issues, fix the encoding first before doing simplified/traditional conversion.
Related Tools
← Home