Replaces part of a text string with a different text string.
81% OFF online library of tutorials for mastering Google Sheets
REPLACE()
Description
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.