SUBSTITUTE practice

SUBSTITUTE replaces every occurrence of one text with another. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

SUBSTITUTE(text, search_for, replace_with, [occurrence_number])

What people get wrong

Use it to strip dashes or spaces from phone numbers before VALUE turns them into numbers.

Google Sheets exercise that use SUBSTITUTE

• Items in a comma listLevel 5Pro

Often used together with: LEN