REPLACE()

Description

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 yet. Stay tuned!