REPLACE
Description
Replaces a number of characters of old_text with new_text, from the start_num position.
Syntax
REPLACE(
old_text
,
start_num
,
num_chars
,
new_text
)
- old_text: The text containing the characters to replace.
- start_num: The position where you want to start replacing text. The value must be 0 or greater.
- num_chars: The number of characters to replace.
- new_text: The text to insert.
Example
Formula | Result |
|---|---|
=REPLACE(A1,10,5,"Production")
Where cell A1 contains
Regional Sales Manager
.
| Regional Production Manager |