Text Formatting

Excel's Remove Duplicates works great on structured rows and columns, but a lot of real-world dedup work — log files, word lists, copy-pasted text — has no spreadsheet structure at all. Here is when each approach actually wins.

A token is roughly four characters or three-quarters of a word in English. Here is the quick reference table, how to estimate from your own text in seconds, and the five cases where the ratio breaks badly.

Word count and character count measure different things and matter for different tasks, from SEO meta tags to tweet limits. Here is exactly when to use each one, with real examples.