8 Awesome Find and Replace Tricks in Excel (Advanced)
Рет қаралды 8,580
Күн бұрынIn this video, I will show you some amazing Find and Replace tricks that you can use in your day-to-day work.
I start with some basics of using Find and Replace in Excel and then deep dive into some advanced things that you can do with it. While most people think that Find and Replace can be used to replace values in the cell, you can also use it to find and replace cell formatting.
00:00 Intro
00:20 Find and Replace Basics
01:56 More Options in Find and Replace
04:33 Using Wildcards in Find and Replace
06:43 Replacing Asterisks
07:48 Find and Replace Cell Color / Formatting
11:21 Find Text and Apply Formatting
12:51 Find Merged Cells
15:01 Converting Dates into Right Format
15:52 Find and Replace Line Breaks
📩 Download Example File - www.dropbox.com/scl/fi/huxk5w...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal
@UKJ28 21 күн бұрын
You are one of those few that i dont feel sleepy watching the videos
@kinreybelleza4515 16 күн бұрын
I feel like you founded Excel 😆. Thanks, Sumit!
@LotfyKozman 29 күн бұрын
You always hit the mark, even though I've turned into a Google Sheet, I can't let the opportunity pass without going through your practical videos. Thank you very much, my old friend Sumit.🙏🙏
@PaulEBrownbill Ай бұрын
Excellent video, especially using the Tilda key, and line breaks. Paul
@MrDhunpagla 27 күн бұрын
Super useful... Thank you so much.. keep educating us
@lydethful Ай бұрын
I find the replace merge with unmerge cells the most useful
@trumpexcel Ай бұрын
Yeah, merged cells can be a pain. I try and avoid using it as much as possible
@Satwant2463 Ай бұрын
Thank you. Very useful.
@elmolewis9123 Ай бұрын
Excellent topic and well covered. 👍
@sahanaanil8723 Ай бұрын
Excellent, thank you for sharing this video which was informative!
@musicsang4882 26 күн бұрын
Excellent. I have become fan of you❤
@user-si5ys2iz8r 26 күн бұрын
Last topic was something unknown and really useful
@bjbrooks 24 күн бұрын
Another excellent video. I've been using Excel since 1990, and never encountered some of the things you covered. Particularly useful are the tips on wildcard searches, format searches, and merged-cell searches. Thank you!
@ravindrakunwar5224 27 күн бұрын
You are the TOP G of Excel
@nadermounir8228 25 күн бұрын
Very nice video thank u very much
@christinavensel510 Ай бұрын
Very helpful. I used Find & Replace in Word, just never thought about using it in Excel. Thank you!
@Luciano_mp Ай бұрын
Very good, nice tips, useful! Thank you!
@trumpexcel Ай бұрын
Glad you found the video helpful 🙂
@montusaha4986 Ай бұрын
Awesome video and very helpful❤
@trumpexcel Ай бұрын
Glad you found the video helpful 🙂
@kannadastories5619 29 күн бұрын
Thank you
@Cabby205 Ай бұрын
Excellent video. I did not know how to use advanced features.
@chrism9037 Ай бұрын
Excellent, there were several I didn’t know, thank you
@info2satish Ай бұрын
1st comment from me! A big fan of your tips and tricks...very helpful 😊
@trumpexcel Ай бұрын
Thanks for the kind words.. Glad you found the video helpful 🙂
@timesavertricks Ай бұрын
As always, you are simply best covering the basic topics but at advance level. Moreover, Proud to have you as an Indian and your Channel in top ten listing for learning about Excel. This video has solved my many queries (mistakes)
@trumpexcel Ай бұрын
Thank you so much for the kind words 😊
@ExcelWithChris Ай бұрын
Loved the last one!
@user-tl5lw7rc3m Ай бұрын
Always provide us with easy and abundant information... Thank you
@trumpexcel Ай бұрын
Thanks for commenting.. Happy to know found the video helpful 🙂
@BKumar6677 Ай бұрын
बहुत बहुत धन्यवाद सर😊
@compdum 26 күн бұрын
My God! No words to express how great this video is going to save me
@IvanCortinas_ES Ай бұрын
Thank you Sir. That's very useful to solve many everyday tasks.
@trumpexcel Ай бұрын
Thanks Iván.. Hope you're well. Glad you found the video helpful 🙂
@yhharishadyar7843 Ай бұрын
Very useful video sir 👌
@chakralamurali Ай бұрын
Excellent sir. You are extraordinary
@atulbharti7880 Ай бұрын
After watching this video, i proud myself that i am on advance level of Find and Replace option.I already know these tricks.I really loved your videos.Especially your VBA series which is very helpful.❤❤❤
@trumpexcel Ай бұрын
Thanks Atul 😀
@prosenjitshaw936 Ай бұрын
Brother I am 37 yrs old.. can I start my carrier just by learning Advance excel & Google sheets .. what additional should I learn ms word , ms powerpoint & ms access .. my mother paralyzed for 11+ yrs .. now I just want to start my career what should I learn pls guide me
@ibrahim82649 24 күн бұрын
Very useful
@RamruttunAubeeluck Ай бұрын
Great Sir
@SAKTHIVEL-cm5ej Ай бұрын
Nice thanks
@asimali5820 25 күн бұрын
Amazing ❤
@haroune711 Ай бұрын
thank you
@yousrymaarouf2931 Ай бұрын
Fantastic
@manosvenianakis9323 Ай бұрын
Great video! I didn't understand the purpose of finding merged cells. I would just select and click unmerge..
@trumpexcel Ай бұрын
If you have multiple places where the cells are merged, you can use Find and Replace to find them all at once and unmerge them.
@manosvenianakis9323 Ай бұрын
@@trumpexcel Thank you for your reply!! I still don't get it though. Selecting a range as you did, then click unmerge.. I think thats faster/easier
@trumpexcel Ай бұрын
Got your point now. Yes, you don't need this if all you want is to unmerge all the cells. Using F&R can be helpful when you want to know if there are merged cells and/or want to select them. Many a times, I have a need to change the value in merged cells or I want to get a list of all the merged cells so I can decide which ones to unmerge
@manosvenianakis9323 Ай бұрын
@@trumpexcel Great! That makes sense! Thanks again for your help!
@nuragvlog2405 26 күн бұрын
If I want to do vice versa of last trick or function? Then??
@user-tl5lw7rc3m Ай бұрын
What.s the name of font you use in Excel
@trumpexcel Ай бұрын
It's Aptos Narrow. I Believe this was made the default font in Microsoft 365
@user-tl5lw7rc3m Ай бұрын
@@trumpexcel Yes👍
@kameshsharma5164 23 күн бұрын
Hello Sir, I need your help. I want a formula that if • if A1=1, a list of any 3 unique random numbers between 1 to 10 should be generated • If A1=2, a list of any 3 unique random numbers between 11 to 15 should be generated • if A1=4, a list of any 3 unique random numbers between 18 to 26 should be generated Please Reply Sir
@ubaidillahmuhammad20 Ай бұрын
It is very pity... Ño given the file ...
@trumpexcel Ай бұрын
My bad. I completely forgot. Thanks for reminding. I have added the file link in the description. Here it is for you - www.dropbox.com/scl/fi/huxk5wna4ohxzrop9jowz/Find-and-Replace.xlsx?rlkey=2om2z4p9s8to8oc3gb8vmtn4p&dl=1
Computer Gyan Guruji
Рет қаралды 56 М.