Excel's Find and Replace Advanced |Surprising Features Part-2

Learn Basic aspect as well as advanced aspect of find and replace features of excel.
Use Excel's amazing feature find and replace to not only find and select all cells data, but to also find and replace cell formatting.You can get even more advanced with this feature by searching for a specific formatting of cell and replacing it with another format.
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
findandreplace#excelfindandreplace #Innozant #exceltutorial

[@kapilkashyap7026]

Amazing use of find and replace 👏 👌. Keep it sir 👍. It show your depth knowledge of topic .

[@Innozant]

Thanks Kapil Ji..Happy Learning ❤️

[@sanishtv]

Amazing sir, All Are very powerful and Life saving tricks. Anyone can give you money at anytime, but not time. And any one who help you saving ur time is so Great! Thanks alot Brother

[@mounikasharma5946]

You are the best teacher 👏👏👏 No one can teach very small to little detail this clearly…you are the best 👏👏👏

[@Innozant]

Thanks Monika, Really means a lot to me..God bless You.Keep learning..Keep Exploring ❤️👍

[@VimalKumar-ih6ik]

Sir You are great, teaching with full of energy and beautiful smile...

[@Innozant]

Thanks

[@uniquemobiletipstricks7714]

Very nice सबसे बढ़िया explain किया detail मे

[@adarshak4767]

Congratulations 👏👏👏🎈
1 Lakh subscriber ho gaye.

[@Innozant]

Thanks dear

[@mohitsharma-ym3km]

Thanks a lot sir. It's a really depth knowledge about find and replace. I am amazed why it didn't cross more than one lakh views .
I watched many videos but you covered everything in beautiful manner. Your videos are great
It's a really powerful content . You covered almost every important thing in two videos. I already subscribed your channel and I will watch videos to increase my Excel knowledge. Thanks sir 👍👍👍👍👍 to upload such wonderful content

[@Innozant]

Thanks a lot Mohit for your wonderful feedback there is a lot to come just wait and watch,Will never let you down🙂🙏

[@iamsainipawan]

Absolutely out of box content 🙏🙏

[@yogeshrao5924]

Thanks दिलीप झा sir Nice Explain

[@janesarkhan9845]

You are great sir❤️❤️❤️❤️❤️

[@kedarson7741]

Great trick Sir

[@bhoopendraraghav9781]

U are the best teacher

[@Innozant]

Make sure you are doing practice as well 😊

[@bhoopendraraghav9781]

@@Innozant yes sir I am doing

[@karankapoor200]

best. video sir 👌🏻👌🏻👌🏻

[@chakralamurali]

Excellent sir

[@brijeshshah574]

Teaching k sath aapki smile bhi bahut achchi hai 😄👌👏🙏

[@Innozant]

😊❤️

[@KuldeepSingh-nq1vi]

Amazing and very Nice tricks

[@dhakafady774]

thanks a lot sir

[@pratyushnigam8956]

Sir when I use replace it is showing only formulas in look in. I am using Excel 2007 tell me sir please what is the problem

[@amandeepsinghbassi1600]

ILOVE DILIP SIR EXCEL TIPS AND TRICKS.Sir how to USE replace function with IF statement in Column to replace Text with Adjacent Matching Column Statement.

[@nithikasn]

Good afternoon Innocent Sir

[@Innozant]

Good Evening..Innozant hai channel ka name♥️👍

[@nithikasn]

Oh.Thank you sir, Your classes are really Helpful

[@nithikasn]

South side Gents having name called Innocent.One cinema actor also haveing his name as Innocent.

[@chandranchiramel4792]

Teaching with great involvement. My doubt reg. substitution INDePaNDaNCa. substitute a with e. There are more than 1 instant!

[@iamsainipawan]

Sir yeh questions kya hum flash fill SE bhi Kar sakte hai

[@Innozant]

Haan kyu nahi but formula bhi Seekhiye acha rhega

[@dhakafady774]

wow sir

[@ravisrivastava6722]

Jabardast sir

[@Innozant]

Thanks Ravi

[@hsgusain2054]

Great sir

[@Innozant]

Thanks dear

[@Rajaji9782]

Hello sir aapke playlist m name naam ki koi playlist nhai h😢.

[@Innozant]

Kaunsa playlist?

[@gauravbhatia7987]

Thnq sir so much

[@Innozant]

Thanks Gaurav ji

[@deepakchauhan4974]

Is there any way we can extract only middle name. Like my name is deepak Kumar Singh and i want to take out only kumar and replace deepak and singh with find and space. please advise how is this possible.

[@Innozant]

Alredat middle name extract video is there kindly watch it dear

[@shrikantbadge3978]

Check Mid Formula by Innozant. Also check Left, Mid, Right combined formula.

[@amitpyasi2819]

Please sir upload macro video

[@Innozant]

kuch time baad

[@sunilchoudhary859]

Sir power pivot ka full tuturiol upload kijiye

[@Innozant]

Offcourse full tutorial hi upload kiya ja raha hai kisi bhi topic ka..Power pivot upload hona start ho gya hai step by step

[@Rajaji9782]

Sir naming range wali playlist nhai h 😢.

[@Innozant]

Basuc excel series me hai

[@rajatdogra96]

=find ka koi formula nhi hai ??

[@tarungiri8156]

Sir ye find replace mere excel pe nahi kaam kr raha.. my 365 use krta hu

[@Innozant]

Kya issue .?

[@tarungiri8156]

Wildcard nahi kaam kr raha..

[@tarungiri8156]

Ho gaya sir..wo excel ka hi kuch error tha

[@susantadas2209]

👌👌

[@pareshparikh7944]

In many number there is a space so i don't sum.the space is in some number behind and some number after.then give me some trick so i can sum.

[@Innozant]

May be it's text not numbers so first use trim to remove space first then convert it into number using value funcation or ALT+D+E+F now try to some those numbers,May it works .

[@AftabAhmed-uw4ki]

Sir plz ms word special chr.ki video bnao plz we are needing plz🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@Innozant]

Ok dear

[@AftabAhmed-uw4ki]

@@Innozant no sir okay nhi plz jaldi upload kro sir🙏🙏🙏🙏🙏🙏

[@tarungiri8156]

Sir Wildcard kaam hi nahi kr raha

[@Innozant]

Kyu

[@RA-rh5lb]

Sir ji aap ne hum log ko namkaran me invite nahi kiya 🤣

[@Innozant]

Hahaha

[@rakeshbareth5024]

तुम ऐसे क्यों सिखाते हो....जैसे बच्चों को सिखा रहे हो...थोडा सीधे ही बताओ करो

[@Innozant]

Kyunki bachon ki tarah samajhaya hua concept insaan lifetime nhi bhool sakta 😊aur Bina twist create kiye hue seehe batane ka matlab aap samne waale ko rata rhe ho na ki concept samjha rahe ho