SUBSTITUTE Function

Freebeginner 15 min4 tasks0/60 pts

SUBSTITUTE replaces specific text inside a string. Optionally give an instance number to change only the 1st, 2nd, … occurrence. It is case-sensitive.

Syntax

SUBSTITUTE(text, old_text, new_text, [instance_num])

Example: =SUBSTITUTE("555-123-4567","-","") removes every dash.

Common mistakes

Using REPLACE when you know the text but not the position.
Forgetting the quotes around old/new text.

UPPER, LOWER, and PROPER Functions TEXTBEFORE & TEXTAFTER