The word Substitute means to replace. The substitute function is somewhat similar to the find-replace command in excel, but is much more flexible and useful.
The substitute function belongs to the text finder class, which is to find a character and replace it with another character.
Simple to understand grammatical structure: Substitute (text, old text, new text, replace from the first).
Case 1: Substitute function basic usage skills
Upgrade the models with the upgrade rule starting with A. Change all models to start with B. The effect is shown in column D.