SUBSTITUTE Text

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 22 of 28.

SUBSTITUTE(text, old_text, new_text) replaces every exact occurrence when the optional instance number is omitted. The match is case-sensitive. Use an empty string as new text to remove a character.

B2 contains AB-12-CD.

Example: =SUBSTITUTE(B2,"-","").

Both hyphens match and are replaced with empty text.

SUBSTITUTE replaces matching text, and omitted instance number means all occurrences.

The practice sheet highlights cells where you should enter formulas. The same formulas must work when the tests replace the input data.

Challenge

Easy

Codes in B2:B4 contain hyphens. Remove all hyphens in C2:C4, preserving every other character.

Enter formulas in the highlighted output cells: C2, C3, C4. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.

Try it yourself

Sheet1