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 ?
@Innozant3 жыл бұрын
Attempt bktke btaiye Chetan...
@VipinSingh-jv9pf9 ай бұрын
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................
SIOM Nashik ka advertisement kyun aa raha hai video ki starting mai? \
@mohammedsiraj34963 ай бұрын
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
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
@Innozant3 жыл бұрын
Aapne 3 char reolace kar diya...zero pass kren..phir insert krega na ki replace
@pawanmaindoli66583 жыл бұрын
@@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
@DEADYBOYS2 жыл бұрын
Sir i have idea is video me last example me right function ka use kr sakte the
@ffmaxvines77004 ай бұрын
Sir kya aap replace & substitute ko aur thoda explain kr sakte ho kya
Teaching methods are impressive and good for beginners
@Innozant3 жыл бұрын
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 🙏
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❤️
@Innozant3 жыл бұрын
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. 🙏❤️
@someonefrom20023 жыл бұрын
@@Innozant Very very thank you sir, it means a lot to me ❤️
@arjuntuteja59554 жыл бұрын
Sir bohot achese smzaate ho
@Innozant4 жыл бұрын
Thanks Arjun,Hope aapko samajh aate h concept 🙏❤️ Basic Excel playlist se step by step dekhiye
@arjuntuteja59554 жыл бұрын
Sir substitute ki aage ki video ni bnai aapne?
@Innozant4 жыл бұрын
Matlab nhi Aaya samjh ..? Advanced substitute questions ki baat Kar re hain kya...start Karne wale hain New series for advanced formula learner
@arjuntuteja59554 жыл бұрын
@@Innozant yes sir advance LEN substitute ye dono k advance kra do
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 Жыл бұрын
Ok..Willl chacke and acknowledge
@pramodbhatt69063 жыл бұрын
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)
@Innozant3 жыл бұрын
Offcourse ,We can..
@Pooja-bd7zm3 жыл бұрын
Very very explained vedio 👍
@Innozant3 жыл бұрын
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)
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
@Innozant2 жыл бұрын
No issue Sharma ji ..Better oppertunity waiting for you
@johndas81733 жыл бұрын
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 Жыл бұрын
Sir agar word main three “B” hai toh sab ko alag letter se kaise change substitute main
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🙏
@Innozant3 жыл бұрын
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-nb4et3 жыл бұрын
@@Innozant Thanks guruji👍
@jituchablani31718 ай бұрын
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-i7b2 ай бұрын
Zero digit place holder work only for 15 digits. Last digit automatically show zero.how it can be rectified?
@Surajkumar-jf8wz2 жыл бұрын
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 Жыл бұрын
Sir please make some change in your video quality because it's showing blur🙏🏻
@harshalagrawal74953 жыл бұрын
How can I use substitute function to replace " sign from my text.
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
@sawaimalhi84393 жыл бұрын
is ka matalb hai aaap nay bahot zyda mehnat ki hoge starting main
@Innozant3 жыл бұрын
off course krna hi chaise mehnat life me humen dear
@virendersroha17544 жыл бұрын
Agr isme name k badle phone no alg krna hoto kya bnega formula
@Innozant4 жыл бұрын
To right use krke len-10..yahan apka right kaam kar jayega ..apply and check it now
@virendersroha17544 жыл бұрын
@@Innozant yes Len 10 se hojayega but agr ph no ki lenth alg ho to like 7 etc
@MukeshSingh-kv4pn3 жыл бұрын
Sir aap shf ke baad snz kiya h aur function m shf se pahle snz karke dikha rahe , why?
@Innozant3 жыл бұрын
Aap concept dekhiye kya karaya ja rha hai . replace function ka application sikhaya ja ra hai
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 🙏
Already Kai's example Hain. Interview cracker series me..alag se BHI tips and tricks me leke aayenge videos
@battlefansshorts89414 жыл бұрын
Ok sir
@pankajkumar-uz9jy4 жыл бұрын
Sir kanika sharma wala example accha h but agar mere pass 20 25 name ho or sabki length alag alag ho to kaise krenge.
@Innozant4 жыл бұрын
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-uz9jy4 жыл бұрын
@@Innozant ohkay sir thanku
@karankapoor2004 жыл бұрын
most important formula sir apsa jada KZbin pay KO I Explain nhi nhi karta h
@Innozant4 жыл бұрын
Thanks Karan..keep watching..learn and share with your friends group.
@karankapoor2004 жыл бұрын
@@Innozant OK
@sagarmathur35353 жыл бұрын
SQL kya charges hai ??
@Innozant3 жыл бұрын
Uske liye aap innozant ke number par WhatsApp karke detail le sakte hain course related
@amitpyasi28193 жыл бұрын
Substitute or replace dono mai kya difference hai
@Innozant3 жыл бұрын
Replace kisi text string ke andar ke kuch part ko badalke kuch aur krega jbke substitute kisi existing text string konbadalke kuch aur
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-jv9pf10 ай бұрын
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".........
@sagarmathur35353 жыл бұрын
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 ..
@Innozant3 жыл бұрын
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 .🙏
@sagarmathur35353 жыл бұрын
@@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...
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-yp1rn4 жыл бұрын
Dear sir... File ka direct link de diya karo... mujhe mil nahi rahi....
@Innozant4 жыл бұрын
His data field ko count krna hai use value field me drop kijiye
@sumitarora25263 жыл бұрын
If replace word is not define or different then
@Innozant3 жыл бұрын
Didnt get you .explain your query
@sanjayrathore85994 жыл бұрын
Sir mere *100 1+ 1- ye formula me kaise lagate he ye samjh nhi ata
@Innozant4 жыл бұрын
Matlab Sanjay ji...ek Baar smjhaiye kya use Karna hai formula me tabhi bata paunga Aise nhi aa Ra samajh
@sanjayrathore85994 жыл бұрын
Sir data he usme mujhe cost value nikalni he
@Innozant4 жыл бұрын
Wo to simple formula lgega his base par calculation Hona hai.
@virendersroha17544 жыл бұрын
=RIGHT(A24,LEN(A24)-10) ans me right k 10 number ni aaye h ye aaye h why 18090921 plez explain
@Innozant4 жыл бұрын
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.
@virendersroha17544 жыл бұрын
@@Innozant sr mujko right k phone no alg krne h isme se to its possible or not
@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
are kyu nhi krega dear.. instance number paas krnege us position k value ko ui change krega
@choudhary20334 жыл бұрын
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,
@Innozant4 жыл бұрын
Extract number only ka video tips and tricks ke andar dekhiye ..without delimeter
@Savitasinghmakeupartist3 жыл бұрын
=Right(text,10)
@TheSentu2 жыл бұрын
Shortcut key for replace
@anuragrawat34352 жыл бұрын
Control + H
@rockzsangeet68673 жыл бұрын
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.
@martinsger3 жыл бұрын
in time of pandemy, and "shake" excell, see here : drive.google.com/file/d/1A6M0DQF9XSK1h_kuPp13omxXFdJdKfpt/view?usp=sharing
@upendrapagare68992 жыл бұрын
Pl show in zoom
@ffmaxvines77004 ай бұрын
With other examples
@vishalrajput9043 жыл бұрын
Sir mujhe mid function samjh nhi aa rha bohot try kar liya
@Innozant3 жыл бұрын
Kyu vishal ji..step by step video dekhiye maone concept samjhaya hai..
@choudhary20334 жыл бұрын
Wow gajab replace ki shadi kardo substitute se to replace ban jayega, Replace Substitute, gajab 😂😂😂😂😂
@Innozant4 жыл бұрын
Haha..Yaad rahega aapko humesha ye example😆❤️🙏
@Aakilkhush3 жыл бұрын
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
@Innozant3 жыл бұрын
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)
@tarjitmalka39784 жыл бұрын
🌟🌟🌟🌟🌟
@maheshkadam28384 жыл бұрын
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
@Innozant4 жыл бұрын
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.sandip62883 жыл бұрын
C column ka replace formula ka ans galat aaya
@Innozant3 жыл бұрын
Kya galat aaya ?
@k.sandip62883 жыл бұрын
@@Innozant aapne C2 me INZ, SHF ke bad diya hain or formula me pahale diya hain.
@k.sandip62883 жыл бұрын
@@Innozant waise jada mistake nahi hain aapne 4 space count kiye the usaki jagah our space count karne honge.
@k.sandip62883 жыл бұрын
@@Innozant aapka example and explanation bahut aachha hain.
@771malik3 жыл бұрын
Abr replace ka example kuch hai answer kuch or hai.. chujju
@Innozant3 жыл бұрын
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 Жыл бұрын
thanks a lot sir
@abdulbasitminhas11493 жыл бұрын
Good explain. But thora zoom kr k explain kryn. Plz