Goal: Update the year in the report title.
SUBSTITUTE finds specific text ("2023") and replaces it ("2025").
Ready...
💻 Formula Structure
=SUBSTITUTE(text, old, new, [instance])
- 1. Old Text: What to find ("2023").
- 2. New Text: What to put there ("2025").
- 3. Instance: (Optional) Which one to swap? Omit to swap all.
-- Update Year from 2023 to 2025
=SUBSTITUTE( A1, "2023", "2025" )
⚠️ Common Pitfalls
🚫 Case Sensitive
SUBSTITUTE is strict. Replacing "Apple" will NOT replace "apple". Use REPLACE if case doesn't matter or you only know the position.
✅ Removing Text
To delete text, replace it with an empty string "".
Example: =SUBSTITUTE(A1, "-", "") removes dashes.