6 Advanced Find and Replace Tricks 🔎 Plus a Bonus Trick

Advanced Find & Replace tricks in Excel can reduce the need for Power Query, macros and advanced formulas. This video covers 6 advanced Find & Replace tricks and a bonus Excel trick at the end. Grab a copy of *Advanced Excel Success* and learn more advanced Excel tricks https://amzn.to/3nt5nqT You will see Find & Replace correcting dates, remove rows that we do not need and to replace formatting at the click of a button. Timings in the video 00:00 - Introduction 00:31 - Fix date structures 01:40 - Replace values in an entire workbook 03:09 - Apply formatting to cells with specific values 04:29 - Find & Replace number formatting 06:27 - Remove rows with specific values 08:40 - Remove every Nth row 10:15 - Bonus: Remove asterisks in a cell Find more great free tutorials at; https://computergaga.com *** Online Excel Courses ***