Description Replaces part of a text string with another text string.
Syntax REPLACE ( orig_text, start_position, num_chars, repl_text )
| Argument | Description |
|---|---|
| orig_text | The original text string. |
| start_position | The character position where the replacement begins.If start_position is greater than the number of characters in orig_text, repl_text is appended to the end of orig_text.If start_position is less than 1, #VALUE! is returned. |
| num_chars | The number of characters to replace. If this argument is negative, #VALUE! is returned. |
| repl_text | The replacement text string. |
Examples This function returns "For the year: 1994":
