8 Awesome Find and Replace Tricks in Excel (Advanced)

In this video, I will show you some amazing Find and Replace tricks that you can use in your day-to-day work. I start with some basics of using Find and Replace in Excel and then deep dive into some advanced things that you can do with it. While most people think that Find and Replace can be used to replace values in the cell, you can also use it to find and replace cell formatting. 00:00 Intro 00:20 Find and Replace Basics 01:56 More Options in Find and Replace 04:33 Using Wildcards in Find and Replace 06:43 Replacing Asterisks 07:48 Find and Replace Cell Color / Formatting 11:21 Find Text and Apply Formatting 12:51 Find Merged Cells 15:01 Converting Dates into Right Format 15:52 Find and Replace Line Breaks 📩 Download Example File - https://www.dropbox.com/scl/fi/huxk5w... ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB ✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c... ✅ Free VBA course - https://bit.ly/excel-vba-course ✅ Free Power Query Course - https://bit.ly/power-query-course ✅ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc... #Excel #ExcelTips #ExcelTutorial #SumitBansal