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 . Replace text starting with the 10th character (the letter S in Sales), and replace 5 characters (replace the word Sales). | Regional Production Manager |