Goal: Replace text based on its Position.
Unlike SUBSTITUTE (which finds words), REPLACE counts characters.
Ready...
💻 Formula Structure
=REPLACE(old_text, start, num_chars, new_text)
- 1. Old Text: The source string.
- 2. Start: Where to begin replacing (Index).
- 3. Num Chars: How many characters to delete.
- 4. New Text: What to insert in that gap.
-- Replace "2023" with "2025"
=REPLACE( A1, 7, 4, "2025" )
⚠️ Common Pitfalls
🚫 Zero Length
If Num_Chars is 0, REPLACE acts like "Insert". It deletes nothing and simply shoves the new text in at the Start position.
🚫 Start Number
Counting starts at 1. If you count incorrectly (e.g. including/excluding spaces), you might overwrite the wrong part of the string.