Excel Comparison
SUBSTITUTE vs REPLACE in Excel and Google Sheets
SUBSTITUTE changes text by value and instance; REPLACE changes a run of characters by position. Tested on banana and SKU-103; SUBSTITUTE is case-sensitive.
#substitute
1 tutorial tagged “substitute”.