SUBSTITUTE

Replaces old text with new text.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Text

Examples

=SUBSTITUTE("Sales Data", "Sales", "Cost")

Result Cost Data

Syntax

SUBSTITUTE(text, old_text, new_text, [instance_num])

text: text required
old_text: text required
new_text: text required
instance_num: number optional

ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.