Find & Replace Articles

Automating Text Transformations in Spreadsheets: SUBSTITUTE, REGEXREPLACE, and Bulk Editing

Excel and Google Sheets have SUBSTITUTE, REGEXREPLACE, PROPER, and TRIM functions that automate text transformation across thousands of cells. Here's chained SUBSTITUTE formulas, REGEXREPLACE for phone number formatting and HTML stripping, and practical workflows for cleaning product exports and generating URL slugs.

Jun 10, 2026

Regex for Data Cleaning: Practical Patterns for Messy Real-World Data

Real-world data — phone numbers, dates, emails, log entries, product codes — arrives inconsistently. Here are the regex patterns for the most common data cleaning tasks: phone normalisation, date standardisation, HTML stripping, whitespace cleaning, and log redaction.

Jun 9, 2026

Find & Replace — Text Substitution with Regex, Case Options & More

Learn how find and replace works beyond basic text substitution — regex patterns, whole word matching, case sensitivity, backreferences — with real examples for data cleaning, templates, and code refactoring.

Jun 6, 2026