REGEXREPLACE

  • Updated

Replaces part of a string using regular expressions.

Sample Usage

REGEXREPLACE("Forehead","head","front")
REGEXREPLACE(A1,A2,A3)

Syntax

REGEXREPLACE(text,regular_expression,replacement)

  • text - The text, a part of which will be replaced. 
  • regular_expression - The regular expression. 
  • replacement - The text which will be inserted into the original text. 

 

Examples

REGEXREPLACE("Forehead","head","front") returns "Forefront". 

Notes

  • This function only works with text as input and returns text as output.