Cool Excel Trick to Find Replace Multiple Words in one go ๐Ÿ‘Œ @chandoo_
Cool Excel Trick to Find Replace Multiple Words in one go ๐Ÿ‘Œ  @chandoo_
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
Cool Excel Trick to Find Replace Multiple Words in one go ๐Ÿ‘ŒSummarize Filtered Values in Excel - Formula TrickAwesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too)The Ultimate Excel Dashboard: Visualize Data Like a ProLearn 80% of DAX in an Hour (with FREE sample file)Learn Excel COPILOT in just 15 minutes and Work Smarter ๐ŸคฏHow to make a Show / Hide SLICER PANEL in Power BI ๐Ÿ’กMake a beautiful and interactive To-Do List with Excel (Easy Tutorial ๐Ÿ‘Œ)Power BI Ecosystem - Explained in 25 minutesBecome an Excel PRO with this complete Dashboard Project ๐Ÿ“ˆYou dont need work email to use Power BI - Easy Fix ๐Ÿ˜ŽDONT tell my boss, but ChatGPT made this Excel dashboard ๐Ÿคซ
Chandoo |

Cool Excel Trick to Find Replace Multiple Words in one go ๐Ÿ‘Œ

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER