Uploaded February 2023 | Updated November 2026, 1 day ago
Here is an awesome Excel trick to find & replace multiple words in one go. I used this recently to bulk rename our products easily.
Imagine you have a bunch of product names in the range C5:C15 and you want to find / replace different words. The list of words to find is in the range G5:G10 and the replacements are in the range F5:F10.
We can use the formula =REDUCE(C5, $G$5:$G$10, LAMBDA(a, b, SUBSTITUTE(a, b, offset(b,0,1))))
to bulk replace all the words with new ones!
NEED TO DO THIS IN POWER QUERY ?
See this video instead - youtu.be/YWAMaas_1AU
ADVANCED EXCEL FORMULAS -
Watch the playlist for more formula tricks and concepts - youtube.com/watch?v=Y3DEt7P62G8&list=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_
#advancedexcel
Here is an awesome Excel trick to find & replace multiple words in one go. I used this recently to bulk rename our products easily.
Imagine you have a bunch of product names in the range C5:C15 and you want to find / replace different words. The list of words to find is in the range G5:G10 and the replacements are in the range F5:F10.
We can use the formula =REDUCE(C5, $G$5:$G$10, LAMBDA(a, b, SUBSTITUTE(a, b, offset(b,0,1))))
to bulk replace all the words with new ones!
NEED TO DO THIS IN POWER QUERY ?
See this video instead - youtu.be/YWAMaas_1AU
ADVANCED EXCEL FORMULAS -
Watch the playlist for more formula tricks and concepts - youtube.com/watch?v=Y3DEt7P62G8&list=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_
#advancedexcel










