Substitute Multiple Values – Excel & Google Sheets

This tutorial will demonstrate how to find and replace multiple values using nested SUBSTITUTE functions.

substitute multiple values Main Function

Substitute Multiple Values

To find and replace multiple values in Excel, we can use the SUBSTITUTE function in a nested formula:

Substitute Multiple Values

How does the formula work?

This formula nests multiple SUBSTITUTE functions together to find and replace values one at a time. The result from the first substitution is fed into the next SUBSTITUTE function and so on. In our example, three substitutions are made. To add more substations, simply nest SUBSTITUTE functions in the formula.

Substitute Multiple Values Using a Reference

Another approach would be to use a reference range instead of typing the values in the formula.

Substitute Multiple Values (IX)

This method works the same way as the pervious method except it uses the INDEX function to reference a find and replace range with the values. Two INDEX functions are needed for each SUBSTITUTE (one for the find value and another for the replace value).

Substitute Multiple Values in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.

substitute multiple values Google Function

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!