Skip to main content
Windward

REPLACE Function

Overviewautotag-wiki-logo.png

The REPLACE function

Replaces each substring of the text with the replacement.

For example

=REPLACE("Alphabet soup", "alpha", "Beta" , "True") returns "Betabet soup"

Syntax

Replace(text, pattern, replacement, ignoreCase)
  • ​text - Required. The text to search  within.
  • pattern - Required. The text to search for.
  • replacement - Required. The text to replace pattern with.
  • ignoreCase - Required. Ignore pattern case wile searching.
  • Was this article helpful?