Syntax
Substitute(String, OldString, NewString [, InstanceNumber])Parameters
OldString- The text to find.
NewString- The replacement text.
InstanceNumberoptional- Replace only this occurrence. All occurrences if omitted.
Examples
=Substitute("2026/10/23", "/", "-")"2026-10-23"