Back to tutorials
Tag Collection
Standardization
2 tutorials grouped around Standardization, so readers can continue by topic.
operations
How to Remove Duplicate Phone Numbers in Excel (with Country Codes & Format Standardization)
Essential skills for marketing/customer service list cleaning: standardize phone number formats, handle country codes, and keep the latest records. Supports standardization of various formats like +86 138-0000-1234, 13800001234, 086-13800001234.
12 min readAug 18, 2025
advanced
Excel Fuzzy Deduplication: Standardization Strategy Checklist, Fuzzy Merge Parameters, Formula & M Code Templates
Find and correctly merge records that look different but are actually the same—covering case, whitespace, symbols, full/half-width, email aliases, phone country codes, approximate spelling, etc.
15 min readAug 18, 2025