The Substitute function

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.

Leave a Comment