#replace

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.