Formulas > =REPLACE()
How to Use REPLACE() in Google Sheets
Description
How To Actually Use REPLACE() in Sheets
REPLACE(text, position, length, new_text)
Try REPLACE yourself
In cell B1, use the REPLACE() function to replace the first 3 characters of the text in cell A1 with 'XYZ'. The result should display 'XYZ' followed by the remaining characters from A1.
Hints (2)
-
Remember that the position starts at 1.
-
The length parameter specifies how many characters to replace.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the REPLACE() formula:
Generate a REPLACE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses REPLACE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a REPLACE() formula