SUBSTITUTE Google Sheet Formula

Generate Google Sheet SUBSTITUTE Formulas in seconds

Try Formula Generator View Examples

Interactive Formula Generator

Formula Generator

Create complex Google Sheets formulas with natural language. Simply describe what you want to calculate.

Upgrade to Sheet Alchemy Pro

Get advanced formulas, batch processing, and priority support

Upgrade Now

Input

Result

Your formula will be displayed here:

Your formula will appear here

Describe what you want to calculate and click Generate

Pro Features Available

Sheet Alchemy Pro includes additional advanced features to enhance your formula generation.

Advanced Formulas

Complex array formulas and dynamic ranges

Batch Processing

Generate multiple formulas at once

Unlimited History

Save and organize all your formulas

SUBSTITUTE Formula Syntax

=SUBSTITUTE("Hello World", "World", "Excel")

Example Use Case

Replacing specific text with new text in a string

Understanding the SUBSTITUTE Formula

The SUBSTITUTE function in Excel replaces specific text within a string with new text, targeting patterns rather than positions. It's a text tool for selective replacement—like swapping words or fixing common typos.

SUBSTITUTE("Hello World", "World", "Excel") returns 'Hello Excel', replacing 'World' with 'Excel'. It takes text, old_text, new_text, and optional instance_num, offering pattern-based substitution.

Why Use SUBSTITUTE?

SUBSTITUTE targets patterns—think word replacement or data transformation. Its content focus differs from REPLACE's position approach, making it ideal for known text changes regardless of location.

Example with Sample Data

Text, Old, New	Formula	Result
'Hello World', 'World', 'Excel'	=SUBSTITUTE("Hello World", "World", "Excel")	Hello Excel
'one two one', 'one', 'X', 2	=SUBSTITUTE("one two one", "one", "X", 2)	one two X
'abc-abc', 'a', 'z'	=SUBSTITUTE("abc-abc", "a", "z")	zbc-zbc

SUBSTITUTE swaps: 'World' for 'Excel', 2nd 'one' for 'X'. It's a text exchanger.