What is SUBSTITUTE?
Replaces specific text within a string. Unlike REPLACE, works with actual text patterns rather than positions.
Syntax
=SUBSTITUTE(text, old_text, new_text, [instance_num])
Example
Formula: =SUBSTITUTE(A1, \
Result: 12/25/2025
How It Works
Replaces all hyphens with slashes. If A1 is '12-25-2025', result is '12/25/2025'. Specify instance_num to replace only nth occurrence.