Excel Formulas to Find and Replace Multiple Values ~ Quickly!!

As we all know, we can use the find and replace function to find multiple same cells and replace them with a value as you need. But sometimes, you need to apply many-to-many replacement simultaneously. In this situation how could you find them quickly? Here, we are going to see the formulas to find and replace multiple values in Excel. Let’s dive into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

If you want to find and replace the text in Excel, you can use the below formula.

=SUBSTITUTE(SUBSTITUTE(A1,INDEX(find,1),INDEX(replace,1)),INDEX(find,2),INDEX(replace,2))

Syntax Explanations:

SUBSTITUTE – This function helps to replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the SUBSTITUTE function.
INDEX – In Excel, the INDEX function is used to repeat characters a given number of times.
A1 – It represents the input value.
Find – It specifies the text that you want to find from the input range.
Replace – It represents the replacing text.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Let’s consider the below example image.

First, we will enter the input text strings in Column B.
Now we are going to find and replace the text which is given in Column E and Column F.

Select any cell and type the above-given formula.

Finally, press the ** ENTER** key, you can get the result as shown below.

Verdict:

So yeah guys this is how you can find and replace the text with multiple values in Excel. Hope you like it. Let me know if you have any doubts regarding this article or any other article on this site.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **