• Home
  • The Substitute function

The Substitute function

The substitute function exercise screenshot

0 comments

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.

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
>