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 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;
computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / alanmurray-computergaga
Instagram ► / computergaga1
Twitter ► / computergaga1

[@Computergaga]

Grab a copy of Advanced Excel Success and learn more advanced Excel tricks amzn.to/3nt5nqT

[@wmfield152]

I just got to this video today. Who knew F&R could do so much? (I didn't!). Another helpful and well-explained tutorial instruction--and much appreciated.

[@Computergaga]

Glad it was helpful! Thank you for your comments.

[@dontown1531]

I have been using Excel since 1993 (ver.5) & still learning useful hints. Thanks for video.

[@Computergaga]

Excellent! Thank you. I'm always learning too.

[@IvanCortinas_ES]

A very complete tutorial. Thank you Alan!!

[@Computergaga]

Thank you very much Iván

[@michalroesler]

Awesome video from Computergaga.

[@Computergaga]

Thank you, Michal 😊

[@RA-rh5lb]

Thanks Alan. Informative video.

[@Computergaga]

No problem. Thank you very much.

[@wayneedmondson1065]

Nice! Thanks Alan!!

[@Computergaga]

Thanks Wayne

[@chrismcneil5712]

Thanks for the helpful video. Cheers.

[@Computergaga]

You're very welcome Chris. Thanks!!

[@planxlsm]

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

[@akramalazrak327]

I really found this feature is good and useful and I mostly use it in my work

[@Computergaga]

Great! It is often overlooked. Thank you Akram.

[@RouletteTipsAndTricks]

Good job as always, you inspire me in the creation of spreadsheets for gambling. Keep doing the good job

[@Computergaga]

Thanks, will do my best.

[@hammeedabdo.82]

If I have an article or a long text of 30 lines in a cell and I want to show 10 lines in the cell and the other rest 20 lines show by a scroll bar. how can I create a scroll bar in a cell if the cell has a long text?

[@Computergaga]

I'm not sure this is possible for a single cell