The SUBSTITUTE Formula in Google Sheets

The SUBSTITUTE formula in Google Sheets allows you to replace specific text within a cell with new text.

To use the SUBSTITUTE formula, you need to follow this syntax: =SUBSTITUTE(text, old_text, new_text, [instance_num])

• "text" is the cell reference or text string that you want to make changes to.
• "old_text" is the text you want to replace within the cell.
• "new_text" is the text you want to replace the old text with.
• [instance_num] is an optional parameter that specifies which occurrence of the old text you want to replace. If you leave it blank, all occurrences of the old text will be replaced.

For example, if you have the text "Hello, world!" in cell A1 and you want to replace "world" with "everyone", you would use the formula =SUBSTITUTE(A1, "world", "everyone"). This will result in the cell displaying "Hello, everyone!".

Now you can use simple words to process data. It's at CapGo AI Sheet. For Google Sheet formula '=SUBSTITUTE(A1, "old", "new")':

You can write a simple instruction "Replace 'old' with 'new' in #A"

In 1 second, all your data is processed!

Try it now at CapGo.AI