Skip to main content

REPLACE

Definition

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

Sample Usage

REPLACE("Spreadsheets", 1, 6, "Bed")

Syntax

REPLACE(text, position, length, new_text)

  • text - The text, a part of which will be replaced.

  • position - The position where the replacement will begin (starting from 1).

  • length - The number of characters in the text to be replaced.

  • new_text - The text which will be inserted into the original text.

Notes

  • This function returns text as the output. If a number is desired, try using the VALUE function in conjunction with this function.

See Also

REGEXREPLACE: Replaces part of a text string with a different text string using regular expressions.

SUBSTITUTE: Replaces existing text with new text in a string.

To use the REPLACE Formula, simply begin with your edited Excellentable.

Then begin typing the REPLACE formula in the area you would like to display the outcome: 

 

 

 

 

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.