8 Awesome Find and Replace Tricks in Excel (Advanced)

Опубликовано: 29 Январь 2025
на канале: TrumpExcel

11,440

609

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