Substitute Multiple Values – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 8, 2023
Download Example Workbook

Download the example workbook

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

substitute multiple values


Substitute Multiple Values

To find and replace multiple values in Excel, use the SUBSTITUTE function within 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

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List