REGEXREPLACE()

Description

Replaces part of a text string with a different text string using regular expressions.

How To Use in Sheets

REGEXREPLACE(text, regular_expression, replacement)

External Links

Google Sheets - RegEx REGEXREPLACE, Functions Exctract, Replace, Match Tutorial - Part 3

Video tutorial series about Google Sheets RegEx functions, how to work with text suing REGEXEXTRACT, REGEXMATCH, REGEXREPLACE functions. You will learn all the basics of regular expression, how to extract text using REGEXEXTRACT, how to replace text using REGEXREPLACE, how to make logical tests and use it for conditional formatting using REGEXMATCH. Unfortunately these functions are not available in Microsoft Excel.