REPLACE / SUBSTITUTE

Google-Sheets

Definition

Text functions. REPLACE replaces part of a text string by position, SUBSTITUTE replaces by matching text.

Example

=SUBSTITUTE("2025-06-02","-","/") changes dashes to slashes.

Stop Juggling Dashboards. Start Growing Get your data flowing today, free plan available.