Hello. I need to replace the contents of multiple cells. I’m using find and replace for this, but the problem is that I need to perform multiple searches with multiple replacements.
Let me explain: I want it to search for a word and replace it with the word specified in the replace field. For example, word1 is replaced by string1, word2 by string2, and so on.
Example:
Find: word1|word2|word3|word4
Replace: string1|string2|string3|string4
This was discussed in another post How find and replace multiple values ? - #2 by RGB-es by user thisc00, but it went unanswered. I hope this clarifies the issue, although I think the solution requires creating a macro , but I’m not an expert in that area.
Regards