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, removing 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 **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ►   / alanmurray-computergaga  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1