REPLACE Google Sheet Formula

Generate Google Sheet REPLACE 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

REPLACE Formula Syntax

=REPLACE("Hello", 2, 3, "xyz")

Example Use Case

Replacing a portion of text with new text

Understanding the REPLACE Formula

The REPLACE function in Excel swaps out a specified portion of a text string with new text, based on position and length. It’s a text tool for editing—like updating codes or fixing strings.

REPLACE("Hello", 2, 3, "xyz") returns 'Hxyzlo', replacing 'ell' (positions 2-4) with 'xyz'. It takes old_text, start_num, num_chars, and new_text, offering precise text surgery.

Why Use REPLACE?

REPLACE edits text—think correcting segments or reformatting. Its positional control makes it a powerful option for targeted string changes, distinct from SUBSTITUTE’s pattern approach.

Example with Sample Data

Text, Start, Length, New	Formula	Result
'Hello', 2, 3, 'xyz'	=REPLACE("Hello", 2, 3, "xyz")	Hxyzlo
'Data123', 1, 4, 'Info'	=REPLACE("Data123", 1, 4, "Info")	Info123
'Test', 3, 1, 'X'	=REPLACE("Test", 3, 1, "X")	TeXt

REPLACE swaps: 'Hxyzlo' from 'Hello', 'Info123' from 'Data123'. It’s a text replacer.