replace

replace(source: text, pattern: text, replacement: text) 🡒 text, const pure function

Replaces in the source text value all the occurrence of pattern by the replacement value.

source = "Hello World!"

show summary "" a1c2 with
  replace(source, "l", "L") // returns "HeLLo WorLd!"
  replace(source, " ", "___") // returns "Hello___World!"
  replace(source, " World", "") // returns "Hello!"

See also

• The SUBSTITUTE function of Excel, omitting the instance_num argument.