Replacing Patterns With REGEXREPLACE

So far you tested patterns and pulled pieces out. Now you will rewrite text: stripping junk characters, reformatting phone numbers, or collapsing extra spaces.

REGEXREPLACE finds every part of the text that matches a pattern and swaps it for replacement text you choose.

This Google Sheets function is the heavy lifter of text cleaning, because it can transform a whole messy column in one pass.

REGEXREPLACE(text, pattern, replacement) takes three arguments: the source text, the pattern to find, and the replacement string.

Unlike REGEXEXTRACT, it replaces every match it finds, not just the first.

The formula below removes all digits from A2 by replacing each digit with an empty string. Room 204 becomes Room .