Excel Exercise


3 minutes

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.

Spreadsheet editor
Nicely done! Keep up the good work.

​Get Good at Excel on Autopilot

Sign up to our newsletter and receive ​Excel articles, tips and tricks delivered straight to your inbox. All you have to do is read them! ​Plus, to get you started, you'll receive a PDF with 200+ Excel shortcuts.