81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Replaces part of a text string with a different text string.

How To Use in Sheets

REPLACE(text, position, length, new_text)

External Links

Google Sheets Replace Function | How to Use Replace | Spreadsheet Function

Use the Google Sheets REPLACE function to replace part or the entire text with different text. You have to specify the starting point from where the replacement will begin, the number of characters to be replaced, and the new text. If you know the position or the starting point of the text, then REPLACE function would be ideal to use. If you do not want to hard-code the starting point, one of the Google Sheets functions you can use to get the starting point is FIND.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.