6 Advanced Find and Replace Tricks 🔎 Plus a Bonus Trick

[@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

[@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.

[@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

[@michalroesler]

Awesome video from Computergaga.

[@Computergaga]

Thank you, Michal 😊

[@chrismcneil5712]

Thanks for the helpful video. Cheers.

[@Computergaga]

You're very welcome Chris. Thanks!!

[@RA-rh5lb]

Thanks Alan. Informative video.

[@Computergaga]

No problem. Thank you very much.

[@wayneedmondson1065]

Nice! Thanks Alan!!

[@Computergaga]

Thanks Wayne

[@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