How to Use Find & Replace in Excel Like a Pro | LUNCH & LEARN | ExcelSifu | 11 AUG 2020

This is a lunch and learn session covering the usage of "Find & Replace" in Microsoft Excel.

00:00 Introduction 00:47 Setting Up Excel File 01:39 Understanding Find and Replace in Excel 04:16 List down all matched cells in an Excel spreadsheet 04:58 Understanding difference between "Replace All" and "Replace" in Excel 05:36 Speedy Shortcuts and Tips to "Find and Replace" 08:19 Find and Replace on Specific Cells in Excel 09:10 Changing Year in All Date Data with Find and Replace 09:40 Replacing All 10:46 Options in "Find and Replace" 11:26 Replacing To Another Value by Matching Colour and Values 14:05 Changing to Different Colour and Values 15:14 Finding and Replacing Across Multiple Worksheets 19:20 Removing All Spaces with Find and Replace 21:47 Finding and Replacing Specific Digit in Numbers 23:36 Easy Way to Scramble Data in Excel 29:29 Summarizing Find and Replace in Excel 30:00 Closing

Connect to me in LinkedIn https://www.linkedin.com/in/excelsifu

Like our FB https://www.facebook.com/WhyExcel/ ... https://www.youtube.com/watch?v=I7wsY4L2PQU