Replace and Substitute Functions | Difference between Replace and Substitute in Excel | in Hindi

  Рет қаралды 94,594

Innozant

Innozant

Күн бұрын

Пікірлер
@chetan1008
@chetan1008 3 жыл бұрын
Sir 4:48 par "Inz" jo pehle aa gya hai voh baad mei aaye jaise upar aapne dikhaya hai to usko baad me le kar aane ke liye formula meiN kya change kiya jaye 🙏 Kya start from 5 ki jgha 9 lga kar 0 lgaya jaye ?
@Innozant
@Innozant 3 жыл бұрын
Attempt bktke btaiye Chetan...
@VipinSingh-jv9pf
@VipinSingh-jv9pf 9 ай бұрын
funfact- we can use substitute instead of replace in every scenario, try to add -INZ- in 824-SHF-6345G with the help of substitute and it will work................
@instagramreels9524
@instagramreels9524 3 жыл бұрын
i became your fan sir superb 👌
@Innozant
@Innozant 3 жыл бұрын
Thanks 🙏❤️
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@vishalbhati912
@vishalbhati912 3 жыл бұрын
Mujhe dono formula aate par thank u instance num ka batane k liye. Wo hi mujhe janna tha. Or dono formula ka difference janna chahta tha
@Innozant
@Innozant 3 жыл бұрын
Thanks Bhati Ji .God bless you Happy learning
@sawaimalhi8439
@sawaimalhi8439 3 жыл бұрын
bahot he acha concept diya sir aaap nay tu
@Innozant
@Innozant 3 жыл бұрын
Thanks Malhi❤
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@prashanthvamsi
@prashanthvamsi 4 жыл бұрын
Very good teaching skills ..
@Innozant
@Innozant 4 жыл бұрын
Thanks Prashant ji for your valuable feedback,It's really motivates me to make some good and share knowledge with all of you Keep watching and share
@Innozant
@Innozant 4 жыл бұрын
Recommend you to watch this kzbin.info/www/bejne/bZ3PaKyYlM2XrLs And give your feedback for the same.
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@aptrends3257
@aptrends3257 2 жыл бұрын
Sir Thanku very much sir your teaching is osm osm
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@shivamshankhdhar89
@shivamshankhdhar89 2 ай бұрын
SIOM Nashik ka advertisement kyun aa raha hai video ki starting mai? \
@mohammedsiraj3496
@mohammedsiraj3496 3 ай бұрын
Hi sir, I have a table which have login for office for eg: 6 times or 7 times or 3 times in a day and have monthly data, how can we replace above data with 1 number please assist on same.thanks
@Prowestgamer
@Prowestgamer 5 ай бұрын
Kya gajab samjhate hain sir jee
@Innozant
@Innozant 5 ай бұрын
Thanks dear .Keep learning
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@nileshjadhav7539
@nileshjadhav7539 3 жыл бұрын
Hi sir agar number hai aur muzhe start me 0 aur mid 2 place pe - dalana hai replace formula use hoga
@Innozant
@Innozant 3 жыл бұрын
Substitute use kar lijiye
@tjr1421
@tjr1421 2 жыл бұрын
Sir mere 2007 excel me formula dalne k baad b "region" ka "zone" nahi horai 🤔?... Uske instance num me kuch dalna hai kya?
@vimalkumar-qt2uc
@vimalkumar-qt2uc 2 жыл бұрын
sir i want to data entrywork online you know any website or plateform i confidance on you please reply to this matter sir
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@pawanwakale8801
@pawanwakale8801 3 жыл бұрын
Sir you explain the example pf replace for example 824-shf-6345G after using replace(old text,start num,num_chars,new text) it shows output only (824-INZ-6345G) not 824-INZ-SHF-6345G
@Innozant
@Innozant 3 жыл бұрын
Aapne 3 char reolace kar diya...zero pass kren..phir insert krega na ki replace
@pawanmaindoli6658
@pawanmaindoli6658 3 жыл бұрын
@@Innozant Kyuki 9 ki jagah 5 liya bhai apne....9 lete tab actual output aata 824-SHF-INZ--6345G, as per Jo Replace ke upar cell mai mantioned hai
@DEADYBOYS
@DEADYBOYS 2 жыл бұрын
Sir i have idea is video me last example me right function ka use kr sakte the
@ffmaxvines7700
@ffmaxvines7700 4 ай бұрын
Sir kya aap replace & substitute ko aur thoda explain kr sakte ho kya
@yashpatil3375
@yashpatil3375 Жыл бұрын
Excellent Sir ji 👌👌👌👍
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@Veenu-yi7pc
@Veenu-yi7pc 3 жыл бұрын
Teaching methods are impressive and good for beginners
@Innozant
@Innozant 3 жыл бұрын
Thanks Sir..Recommend you to start your learning journey from Playlist Basic Excel onwards Step by Step then Proceed with Advance Series and Interview cracker (Video in sequence Playlist available in Video description) Happy Learning 🙏
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@abhisheksingh398
@abhisheksingh398 2 жыл бұрын
Sir agar apke pass ake traning lene ke lie aye to Delhi main apka institute h kya sir
@Innozant
@Innozant 2 жыл бұрын
Yes. New Ashok Nagar Delhi me.hain Innozant Institute
@abdulbasitminhas1149
@abdulbasitminhas1149 3 жыл бұрын
Good explain. But thora zoom kr k explain kryn. Plz
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@mohitsharma-ym3km
@mohitsharma-ym3km 4 жыл бұрын
Substitute (A1, Right (A1,10),""). For last example.
@V2000-c6h
@V2000-c6h 3 жыл бұрын
Sir kisi text se pehle tick ka nishan kaise lagaye custom formatting.
@Innozant
@Innozant 3 жыл бұрын
Cutstom formatting se better conditional formatting use krke concatenate kr skte h symbol na
@abdulalim-ni4mv
@abdulalim-ni4mv 4 ай бұрын
Bohot khub
@dhakafady774
@dhakafady774 Жыл бұрын
thanks a lot sir
@deysub1
@deysub1 2 жыл бұрын
Can you tell any method to replace texts in a or multiple text boxes (inserted from Insert >Shape >Textbox) in excel. Thank you
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@someonefrom2002
@someonefrom2002 3 жыл бұрын
Sir mai ITI kar rha hoon Govt. ITI Noida se, Computer Operator and Programming Assistant trade se aur graduation bhi kr rha hoon DU-SOL se abhi main 3rd year me aane wala hoon, mujhe pahle se bhi Decent knowledge thi MS Excel me but mai abhi starting se aapke videos dekh kar skill strong kr rha hoon, abhi mai iss video tak pahuncha hoon, notes bhi bna rha hoon, practice bhi kr rha hoon, Sir koi assignment aap de dete toh kaafi achha hota, aur sir aap mere ko koi suggestion ya margdarshan bhi dede. Sir mai Noida sector 62 me rhta hoon. Thank you sir❤️
@Innozant
@Innozant 3 жыл бұрын
Complete Tutorial steo by step padhaye gaye hain..aap seekhiye aur assigment sheet se practice bhi kariye..MIS interview cracker ke questions khudde attempt krna hai apko sab. 🙏❤️
@someonefrom2002
@someonefrom2002 3 жыл бұрын
@@Innozant Very very thank you sir, it means a lot to me ❤️
@arjuntuteja5955
@arjuntuteja5955 4 жыл бұрын
Sir bohot achese smzaate ho
@Innozant
@Innozant 4 жыл бұрын
Thanks Arjun,Hope aapko samajh aate h concept 🙏❤️ Basic Excel playlist se step by step dekhiye
@arjuntuteja5955
@arjuntuteja5955 4 жыл бұрын
Sir substitute ki aage ki video ni bnai aapne?
@Innozant
@Innozant 4 жыл бұрын
Matlab nhi Aaya samjh ..? Advanced substitute questions ki baat Kar re hain kya...start Karne wale hain New series for advanced formula learner
@arjuntuteja5955
@arjuntuteja5955 4 жыл бұрын
@@Innozant yes sir advance LEN substitute ye dono k advance kra do
@tt_badmash_9560
@tt_badmash_9560 Жыл бұрын
Excellent sir
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@mohdayazuddinshaikh4454
@mohdayazuddinshaikh4454 Жыл бұрын
Sir I think there is some formula mistake at time stamp 4:57 as result was not as per desired format, by mistake...just highlighted to correct the same. Thanks for an amazing Excel series.
@Innozant
@Innozant Жыл бұрын
Ok..Willl chacke and acknowledge
@pramodbhatt6906
@pramodbhatt6906 3 жыл бұрын
Sir, Can we use IF function with substitute. Ex- There are so many names in excel & we want to replace Kumar with Sharma. Name 1- Pramod Kumar- Output will be Pramod Sharma Name 2- Pramod Chandra- Output will be Pramod Chandra (No Change)
@Innozant
@Innozant 3 жыл бұрын
Offcourse ,We can..
@Pooja-bd7zm
@Pooja-bd7zm 3 жыл бұрын
Very very explained vedio 👍
@Innozant
@Innozant 3 жыл бұрын
Thanks Pooja for your valuable appreciation dear. Recommend you to statt your learning journey from playlist Basic Excel step by step followed wity Advanced (Playlist in sequence available in latest video description)
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@ShubhamSharma-rb1dj
@ShubhamSharma-rb1dj 2 жыл бұрын
I was asked a question related substitute.. that time I didn't know the use of this formula that's why I didn't select . I wish had seen this video before I would have been selected
@Innozant
@Innozant 2 жыл бұрын
No issue Sharma ji ..Better oppertunity waiting for you
@johndas8173
@johndas8173 3 жыл бұрын
Sir aap price se decimal name se multiply karna hai example 100kg*Rs.140 challenging wala tuff formula ka video banao left right mid & ek advance formula jo apko is video me mil jayega
@TrendingMuzic25
@TrendingMuzic25 Жыл бұрын
Sir agar word main three “B” hai toh sab ko alag letter se kaise change substitute main
@timeclone34
@timeclone34 2 жыл бұрын
SIR U ARE TOO GOOD
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@rajd4739
@rajd4739 Жыл бұрын
Very helpful video
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@aijazabro1332
@aijazabro1332 Жыл бұрын
MashaAllah. Wonderful explaination.
@Innozant
@Innozant Жыл бұрын
Thanks dear
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@dpak_sharma
@dpak_sharma 2 жыл бұрын
Thank you। so much sir 👌
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@soniabhi8327
@soniabhi8327 Жыл бұрын
Is video ka next part ki link dijiye sir 🙏
@Innozant
@Innozant Жыл бұрын
Usi playlist me hai dear
@hemmadys
@hemmadys 2 жыл бұрын
Sir in that zone example if we had put 7 characters for region instead of 6, then region could had been replaced with zone. Can we do it this way?
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@AbhishekKumar-nb4et
@AbhishekKumar-nb4et 3 жыл бұрын
Sir Es dono me antar kya hai . Kanika Gupta to substitute se bhi ho jayega n then why replace? Kya antar hai dono me .. please tell me in one line🙏
@Innozant
@Innozant 3 жыл бұрын
Dear replace aur substitute dono function ka purpose hi alag hai .ek (replace) part of text string ko replace krta hai kisi dusre text se aur dusra(substitute) existing text ko replace karya hai dear
@AbhishekKumar-nb4et
@AbhishekKumar-nb4et 3 жыл бұрын
@@Innozant Thanks guruji👍
@jituchablani3171
@jituchablani3171 8 ай бұрын
Sir Suppose ek cell (A1) me mera Full name h (Jeetender Kanayalal Chablani) to mujhe text ke functions use karke mujhe uska last name (Chablani) nikaalna h toh wo kaise hoga???
@KuldeepHooda-i7b
@KuldeepHooda-i7b 2 ай бұрын
Zero digit place holder work only for 15 digits. Last digit automatically show zero.how it can be rectified?
@Surajkumar-jf8wz
@Surajkumar-jf8wz 2 жыл бұрын
Sir instance no smjh ni aaya sir aur utube chhan mara pr kahi v ni smjh paya aap bata do ek bar aur isme apne bataya h mujhe pata he nahi chala h ki kya change hua idhr sb change ho gya
@vishaltanwar8318
@vishaltanwar8318 Жыл бұрын
Sir please make some change in your video quality because it's showing blur🙏🏻
@harshalagrawal7495
@harshalagrawal7495 3 жыл бұрын
How can I use substitute function to replace " sign from my text.
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@kashrafali2258
@kashrafali2258 2 жыл бұрын
1. kiya condition formating sirf highlight ke liye hoga filter ke liye nahi Agar nahi to kiya conditional formating aur filter milake filter kar sakthe hai. Mere pass 2 coloum hai. ek me date. doosre may task. jaise hi main date ko update karta hoon madlab control : dalta hoon mujhe referesh karna hai thabi vo filter hota hai. kiya bina referesh ke vo hide nahi hoga. kiya upai hai
@sawaimalhi8439
@sawaimalhi8439 3 жыл бұрын
is ka matalb hai aaap nay bahot zyda mehnat ki hoge starting main
@Innozant
@Innozant 3 жыл бұрын
off course krna hi chaise mehnat life me humen dear
@virendersroha1754
@virendersroha1754 4 жыл бұрын
Agr isme name k badle phone no alg krna hoto kya bnega formula
@Innozant
@Innozant 4 жыл бұрын
To right use krke len-10..yahan apka right kaam kar jayega ..apply and check it now
@virendersroha1754
@virendersroha1754 4 жыл бұрын
@@Innozant yes Len 10 se hojayega but agr ph no ki lenth alg ho to like 7 etc
@MukeshSingh-kv4pn
@MukeshSingh-kv4pn 3 жыл бұрын
Sir aap shf ke baad snz kiya h aur function m shf se pahle snz karke dikha rahe , why?
@Innozant
@Innozant 3 жыл бұрын
Aap concept dekhiye kya karaya ja rha hai . replace function ka application sikhaya ja ra hai
@dynasticdraculagaming8668
@dynasticdraculagaming8668 2 жыл бұрын
Nice💗
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@computerorigin7434
@computerorigin7434 3 жыл бұрын
Sir agr text k andr jo character hain khi 5 hain khi p 8 hain Phr hum usko replace kese krenge???? Eg- Amit Gupta Subhash Gupta Dono mein Gupta ki jgah Sharma krna ho to Amit (4 character) Subhash (7 character) Result kese aayega Plzz reply 🙏
@VikashKumar-vp7rv
@VikashKumar-vp7rv 7 ай бұрын
Best sir
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@battlefansshorts8941
@battlefansshorts8941 4 жыл бұрын
Advance substitute par video banao sir
@Innozant
@Innozant 4 жыл бұрын
Already Kai's example Hain. Interview cracker series me..alag se BHI tips and tricks me leke aayenge videos
@battlefansshorts8941
@battlefansshorts8941 4 жыл бұрын
Ok sir
@pankajkumar-uz9jy
@pankajkumar-uz9jy 4 жыл бұрын
Sir kanika sharma wala example accha h but agar mere pass 20 25 name ho or sabki length alag alag ho to kaise krenge.
@Innozant
@Innozant 4 жыл бұрын
Saare name me common jo hoga use find krenge then replace jaise ki space common first aur last name ke bichme..Wait kijiye aayega advance text Function video..step by step seekhte chaliye.hv a great day
@pankajkumar-uz9jy
@pankajkumar-uz9jy 4 жыл бұрын
@@Innozant ohkay sir thanku
@karankapoor200
@karankapoor200 4 жыл бұрын
most important formula sir apsa jada KZbin pay KO I Explain nhi nhi karta h
@Innozant
@Innozant 4 жыл бұрын
Thanks Karan..keep watching..learn and share with your friends group.
@karankapoor200
@karankapoor200 4 жыл бұрын
@@Innozant OK
@sagarmathur3535
@sagarmathur3535 3 жыл бұрын
SQL kya charges hai ??
@Innozant
@Innozant 3 жыл бұрын
Uske liye aap innozant ke number par WhatsApp karke detail le sakte hain course related
@amitpyasi2819
@amitpyasi2819 3 жыл бұрын
Substitute or replace dono mai kya difference hai
@Innozant
@Innozant 3 жыл бұрын
Replace kisi text string ke andar ke kuch part ko badalke kuch aur krega jbke substitute kisi existing text string konbadalke kuch aur
@amitpyasi2819
@amitpyasi2819 3 жыл бұрын
Thank you sir
@RA-rh5lb
@RA-rh5lb 2 жыл бұрын
Thank you
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@OfficialComputerWorkTricks
@OfficialComputerWorkTricks 2 жыл бұрын
* ko kaise replace kre
@Innozant
@Innozant 2 жыл бұрын
Using tilde
@OfficialComputerWorkTricks
@OfficialComputerWorkTricks 2 жыл бұрын
@@Innozant thanks sir ho gya
@Itzsandeep001
@Itzsandeep001 Жыл бұрын
Sir replace ke formule m ek galti hai humko (824-SHf-INZ-6345G) ye aproch chahiye tha lekin jo output aaya hai vo (824-INZ-SHZ-6345G) aaya hai
@AlimKhan-bl5sh
@AlimKhan-bl5sh 5 ай бұрын
Jo start number me 5 kii jagah 8 daal dena.. Or double code me inz se pehle hifun laga dena... Jese.. Replace(old text., 8,0,"-inz")
@bestsong340
@bestsong340 7 ай бұрын
Very nice ❤️❤️❤️
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@tjr1421
@tjr1421 2 жыл бұрын
Sir mene replace me kanika sharma eg. =Replace(A13,8,6,"Sharma") toh output barabar aaya. Lekin apne 6 k badle 5 daala fir b apka output sahi aaya. Aisa kaise sir?.mene 6 sharma k according dala aur apne 5 Gupta k according.
@VipinSingh-jv9pf
@VipinSingh-jv9pf 10 ай бұрын
It's totally fine because word "gupta" is having 5 letters, if you take 4 instead of 5/6 then it will change only "Gupt", and "a" will still remain same in "Gupta" and new word we will get after applying function is "Sharmaa".........
@sagarmathur3535
@sagarmathur3535 3 жыл бұрын
One feedback replace mein jab aapne 0 lagaya tha to sir ..please explain logic behind it .... Replace ke basic fundamentals se wo concept divert kar raha hai... Kaise samjhe usko aur ..
@Innozant
@Innozant 3 жыл бұрын
Dear 0 ka matal maine btaya ki replace kisi ko karna nahi hai wahan apar inersert karna hai isliye 0 ydi 1 kar denge ti ek char replace kr dega wo hum nhi chahte hain .🙏
@sagarmathur3535
@sagarmathur3535 3 жыл бұрын
@@Innozant thank you sir I love to watch your videos ...you are providing something different study material which is unique compare to other youtubers ... Thanks for providing excel coaching on KZbin ...please start VBA series too...
@ChandanKumar-gp8zw
@ChandanKumar-gp8zw 2 жыл бұрын
Thanks
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@kumardilip7217
@kumardilip7217 2 жыл бұрын
Sir please assist as below given query Replace error value in coulme "Data3" with "Ram" Data1 data2 Data3 150. 329. 1 32 345. 45 320. 0. #Div/0! #N/A. 3a. #N/A
@Jitenderkumar-yp1rn
@Jitenderkumar-yp1rn 4 жыл бұрын
Dear sir... File ka direct link de diya karo... mujhe mil nahi rahi....
@Innozant
@Innozant 4 жыл бұрын
His data field ko count krna hai use value field me drop kijiye
@sumitarora2526
@sumitarora2526 3 жыл бұрын
If replace word is not define or different then
@Innozant
@Innozant 3 жыл бұрын
Didnt get you .explain your query
@sanjayrathore8599
@sanjayrathore8599 4 жыл бұрын
Sir mere *100 1+ 1- ye formula me kaise lagate he ye samjh nhi ata
@Innozant
@Innozant 4 жыл бұрын
Matlab Sanjay ji...ek Baar smjhaiye kya use Karna hai formula me tabhi bata paunga Aise nhi aa Ra samajh
@sanjayrathore8599
@sanjayrathore8599 4 жыл бұрын
Sir data he usme mujhe cost value nikalni he
@Innozant
@Innozant 4 жыл бұрын
Wo to simple formula lgega his base par calculation Hona hai.
@virendersroha1754
@virendersroha1754 4 жыл бұрын
=RIGHT(A24,LEN(A24)-10) ans me right k 10 number ni aaye h ye aaye h why 18090921 plez explain
@Innozant
@Innozant 4 жыл бұрын
Right galat chalaye h isme left use karen..right Function text ko end of the text string se leke aata hai..khud sochiye kaise layega phir.? Left ke saath len paas kijiye .again video repeat krke dekhiye kya sikhaya hai right func ka concept..ok .achi baat hai try kr re h kuch naya.good.
@virendersroha1754
@virendersroha1754 4 жыл бұрын
@@Innozant sr mujko right k phone no alg krne h isme se to its possible or not
@manoharjha509
@manoharjha509 Жыл бұрын
Sir,ye Jo aapne dusre Khiladi wala tarika smjhaya hai ye mujhe bilkul b smjh nhi aa rha h .mene ise 3 se 4 baat samjhne ki koshish ki hai but muje data me koi difference Nazar nhi aa rha h (instance number ) Thoda alag tarike se smjhaye please 🙏😢 Manohar jha from Rajasthan,Jaipur
@prathameshrane7607
@prathameshrane7607 Жыл бұрын
INZ age Aya SHF ke yeh to galat hua na
@gauravbhatia7987
@gauravbhatia7987 4 жыл бұрын
Thnq sir
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@rsk98
@rsk98 2 жыл бұрын
Ravi- Shankar * Kumar how to remove -, * both
@neerajsingh-oz5od
@neerajsingh-oz5od 3 жыл бұрын
Instance numbers in substitute work nhi kar raha
@Innozant
@Innozant 3 жыл бұрын
are kyu nhi krega dear.. instance number paas krnege us position k value ko ui change krega
@choudhary2033
@choudhary2033 4 жыл бұрын
Agar Isme Se Hame only mobile no. nikalna ho 10 digit ka right side se to wo kaise niklega, kyoki kyoki name jo hai wo ek jaise digit nahi hai kisi mai 8 kisi mai 9, to ye kaise hoga, jaise name nikala, kyoki hame pata tha ki ye sabhi mobile no. 10 digit ka,
@Innozant
@Innozant 4 жыл бұрын
Extract number only ka video tips and tricks ke andar dekhiye ..without delimeter
@Savitasinghmakeupartist
@Savitasinghmakeupartist 3 жыл бұрын
=Right(text,10)
@TheSentu
@TheSentu 2 жыл бұрын
Shortcut key for replace
@anuragrawat3435
@anuragrawat3435 2 жыл бұрын
Control + H
@rockzsangeet6867
@rockzsangeet6867 3 жыл бұрын
In MS-Excel, How can I Change as follows (automatically)- 1 into 6, 2 into 7, 3 into 8, 4 into 9, 5 into 0, 6 into 1, 7 into 2, 8 into 3, 9 into 4, 0 into 5. As I type 248 in a cell, I would get 793 as result in another cell, As I type 806 in a cell, I would get 351 as result in another cell, As I type 100 in a cell, I would get 655 as result in another cell.
@martinsger
@martinsger 3 жыл бұрын
in time of pandemy, and "shake" excell, see here : drive.google.com/file/d/1A6M0DQF9XSK1h_kuPp13omxXFdJdKfpt/view?usp=sharing
@upendrapagare6899
@upendrapagare6899 2 жыл бұрын
Pl show in zoom
@ffmaxvines7700
@ffmaxvines7700 4 ай бұрын
With other examples
@vishalrajput904
@vishalrajput904 3 жыл бұрын
Sir mujhe mid function samjh nhi aa rha bohot try kar liya
@Innozant
@Innozant 3 жыл бұрын
Kyu vishal ji..step by step video dekhiye maone concept samjhaya hai..
@choudhary2033
@choudhary2033 4 жыл бұрын
Wow gajab replace ki shadi kardo substitute se to replace ban jayega, Replace Substitute, gajab 😂😂😂😂😂
@Innozant
@Innozant 4 жыл бұрын
Haha..Yaad rahega aapko humesha ye example😆❤️🙏
@Aakilkhush
@Aakilkhush 3 жыл бұрын
Sir aapki vedio kamaal ki hai but sequence nahi hai like ham ye vedio dekh rahai hai hame pta nahi hai ki aapne is se phele kon si vedio banayi hai ya iske bad kon si vedio banayi hai vedio ka koi serial no. ya class no nahi hai please create sequence no. in vedio
@Innozant
@Innozant 3 жыл бұрын
Kashif sahab aisa sequence videos aapko sayad kisi platform par nhi milega.. Harek ka playlist bana hua hai kaise padhna hai wo bji bataya gaya hai. Aap Playlist me jaiye wahan Basic excel ka playlist bana hua hai 73 video hain in sequence..wahan se padhna start kariye. Is link sw dekhiye kaise padhai start karna hai aapko kzbin.info/www/bejne/aGqWZmhmar1mr7c Saath hi video description me (Playlist i. Sequence ka link diya gya hai ki kaise start karna hai playlistwise)
@tarjitmalka3978
@tarjitmalka3978 4 жыл бұрын
🌟🌟🌟🌟🌟
@maheshkadam2838
@maheshkadam2838 4 жыл бұрын
Bro muje samaj nahi aaya aapki video replace Aap fir se aapni video dheke or use sudhare or muje samjaye replace kese sarna he B24-SHF-INZ-6345G yese he aapna likha huaa but answer B24-INZ-SHF-6345G
@Innozant
@Innozant 4 жыл бұрын
Mahesh Ji Video Ko sudharne ki jarurat Nahi hai..Aap dubara dekhiye aur samajhne ki koshish kijiye ki hum Karna kya chahte Hain wahi samjhaya gya hai. Humeen. SHF ko replace Nahi Karna hai Usi position par IBM ko insert Karna hai isliye 0 (zero) pass Kiya hai jisse ki output me IBM insert hoke Aaye ❤️🙏
@k.sandip6288
@k.sandip6288 3 жыл бұрын
C column ka replace formula ka ans galat aaya
@Innozant
@Innozant 3 жыл бұрын
Kya galat aaya ?
@k.sandip6288
@k.sandip6288 3 жыл бұрын
@@Innozant aapne C2 me INZ, SHF ke bad diya hain or formula me pahale diya hain.
@k.sandip6288
@k.sandip6288 3 жыл бұрын
@@Innozant waise jada mistake nahi hain aapne 4 space count kiye the usaki jagah our space count karne honge.
@k.sandip6288
@k.sandip6288 3 жыл бұрын
@@Innozant aapka example and explanation bahut aachha hain.
@771malik
@771malik 3 жыл бұрын
Abr replace ka example kuch hai answer kuch or hai.. chujju
@Innozant
@Innozant 3 жыл бұрын
Malik Sahab sab khairiyat hai? Video ko nind me to nhi dekh liye ki example kuch aur answer kuch aur mil rha hai,ya naye member Jude hain bus kuch bhi comment post krne ke liye 😀😀 Video start se dekhoye yadi seekhne ke maqsad se jude hain to..jo video ka title hai wahi content hai❤️
@dhakafady774
@dhakafady774 Жыл бұрын
thanks a lot sir
@abdulbasitminhas1149
@abdulbasitminhas1149 3 жыл бұрын
Good explain. But thora zoom kr k explain kryn. Plz
@Innozant
@Innozant 3 жыл бұрын
Thanks Abdul..Sure dear zoom la dhyan rakhenge
@dhakafady774
@dhakafady774 Жыл бұрын
thanks a lot sir
@dhakafady774
@dhakafady774 Жыл бұрын
thanks a lot sir
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@dhakafady774
@dhakafady774 Жыл бұрын
thanks a lot sir
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/nKWVi6Kae7CYpKssi=GeF8b_iufOLw6GKc
@dhakafady774
@dhakafady774 Жыл бұрын
thanks a lot sir
@dhakafady774
@dhakafady774 Жыл бұрын
thanks a lot sir
@dhakafady774
@dhakafady774 Жыл бұрын
thanks a lot sir
@ramkishoryadav9087
@ramkishoryadav9087 5 ай бұрын
kzbin.info/www/bejne/o3vMdnWge51lmbcsi=2c4JOkPZjhWpeMsQ
Excel's Find and Replace Advanced |Surprising Features Part-1
12:53
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН
Don’t Choose The Wrong Box 😱
00:41
Topper Guild
Рет қаралды 62 МЛН
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
12:29
Kenji Explains
Рет қаралды 111 М.