SUBSTITUTE

Replace text based on content

Sponsored Link

SUBSTITUTE
Purpose 
Replace text based on content
Return value 
The altered text.
Syntax 
=SUBSTITUTE (text, old_text, new_text, [instance])
Arguments 
  • text - The text to change.
  • old_text - The text to replace.
  • new_text - The text to replace with.
  • instance - [optional] The instance of old_text to replace with new_text. Optional; if not supplied, all instances of old_text are replaced with new_text.
Usage notes 

Use the SUBSTITUTE function when you want to replace text based on its content, not position.

SUBSTITUTE finds and replaces old_text with new_text in a text string. Instance limits SUBSTITUTE replacement to one particular instance of old_text. If instance is not supplied, all instances of old_text are replaced with new_text.

instance is optional. if not supplied, all instances of old_text are replaced with new_text.

Use SUBSTITUTE to replace text based on content. Use REPLACE when to replace text based on its location.

SUBSTITUTE is case-sensitive and does not support wildcards.

Sponsored Link

0 votes. 0 / 5