The Substitute function

Beginner

You can use the Substitute function for all kinds of textual replacing.

Try changing the X in cell A2 below into a 1 by using SUBSTITUTE in cell B2. Also, change only the second occurrence of the X in A5. Do that using a Substitute in B5.

Need some help?

Related function(s)

SUBSTITUTE

More exercises

Basic Iferror exerciseBeginner

Combining first and last names using ConcatenateBeginner

Counting blank rowsBeginner

Creating an IFNOTERROR functionBeginner

Back to exercises overview

Exercise

The Substitute function

Beginner

You can use the Substitute function for all kinds of textual replacing.

Try changing the X in cell A2 below into a 1 by using SUBSTITUTE in cell B2. Also, change only the second occurrence of the X in A5. Do that using a Substitute in B5.