Skip to main content
Windward

SUBSTITUTE Function

Overviewautotag-wiki-logo.png

The SUBSTITUTE function

Replaces each substring of the text with the replacement.

For example

=substitute("Sales Data Sales","Sales","Data") returns "Data Data Data"

Syntax

=SUBSTITUTE(text, old_text, new_text, instance_num)
  • ​text  - Required. The text to search within.
  • old_text - Required. The text to search for.
  • new_text - Required. The text to replace with.
  • instance_num - Optional. Number represent which occurence of old_text to replace with the new_text.
  • Was this article helpful?