REPLACE
Replaces part of a string value, based on the number of specified characters, with a different text.
Syntax
=REPLACE(OldText, StartAt, NumChars, NewText)
Arguments
| Name | Type | Description |
|---|---|---|
| OldText | String | String in which to replace characters. |
| StartAt | Number | Character position in OldText at which replace starts. |
| NumChars | Number | Number of characters from StartAt to be replaced by NewText. |
| NewText | String | The text which will replace specified characters in OldText. |
Return
| Type | Description |
|---|---|
| String | The replaced Text. |
Examples
| Formula | Result | Comment |
|---|---|---|
| "Replace me later" |