Generic Formula to Find Multiple Items and Replace With One Value =SUBSTITUTE(SUBSTITUTE(original_text,INDEX(find_list,1),"replacer_text"),INDEX(find_list,2),"replacer_text") So with that said, let's see the generic formula. The SUBSTITUTE will need help from the INDEX function also. We will use multiple SUBSTITUTE functions to find multiple values and replace multiple values. We used this function to replace a given text in a string with another text. But what if we have multiple items to replace with one or multiple items? How do we replace multiple items in Excel? In this article we will learn exactly that. We just press CTRL+H to open the find and replace dialog and use it to replace a single value. We know how to find and replace a single item in the sheet at one time. In this article, we will learn How to Find and Replace Multiple Values in Excel.
0 Comments
Leave a Reply. |