Find & Replace Can Do This? (Most People Have No Idea)
From MyOnlineTrainingHub Ā· Ā· 9 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Find and Replace tricks in Excel most people have never used: replace by format, wildcards, fix formulas, whole-workbook replace, and line breaks. š©āš« Become an Excel Expert with my course: https://bit.ly/findreplace26course ā¬ļø Download the example file here and follow along: https://bit.ly/findreplace26file
LEARN MORE ===========
š° EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
šÆ FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
š¬ EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
ā² TIMESTAMPS ============== 0:00 The Find and Replace options most people never open 0:26 Change cell formatting without touching the values 2:17 Clean up messy data with wildcards 4:56 Update hard-coded values inside your formulas 6:33 Replace text across an entire workbook at once 7:34 Find and replace line breaks (the hidden trick) 9:00 Excel tricks you wish someone had shown you years ago
#Excel #ExcelTools #ExcelTips