Replace and Substitute Functions | Difference between Replace and Substitute in Excel | in Hindi
Вставка
- Опубліковано 3 жов 2024
- Learn how to use the REPLACE and SUBSTITUTE functions by watching amazing explanation with example demonstrated by host.
1. Use or Replace function with example
2. Use of Substitute function with exaple
3. Use of find and len function together to extract name from list
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. .
#substitute#findandreplace #Innozant #excelsubstitutefunction
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/n.gif)
thanks a lot sir
Bohot khub
i became your fan sir superb 👌
Thanks 🙏❤️
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Kya gajab samjhate hain sir jee
Thanks dear .Keep learning
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
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................
bahot he acha concept diya sir aaap nay tu
Thanks Malhi❤
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
SIOM Nashik ka advertisement kyun aa raha hai video ki starting mai?
\
Sir kya aap replace & substitute ko aur thoda explain kr sakte ho kya
Very good teaching skills ..
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
Recommend you to watch this
ua-cam.com/video/7ll7yb_hdvY/v-deo.html
And give your feedback for the same.
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
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
Thanks Bhati Ji .God bless you Happy learning
Substitute (A1, Right (A1,10),""). For last example.
Sir Thanku very much sir your teaching is osm osm
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Very nice ❤️❤️❤️
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
Teaching methods are impressive and good for beginners
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 🙏
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
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)
Offcourse ,We can..
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 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❤️
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. 🙏❤️
@@Innozant Very very thank you sir, it means a lot to me ❤️
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
Aapne 3 char reolace kar diya...zero pass kren..phir insert krega na ki replace
@@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
Good explain. But thora zoom kr k explain kryn. Plz
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
Sir i have idea is video me last example me right function ka use kr sakte the
SIR U ARE TOO GOOD
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Sir please make some change in your video quality because it's showing blur🙏🏻
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 ?
Attempt bktke btaiye Chetan...
Very helpful video
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
MashaAllah.
Wonderful explaination.
Thanks dear
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Excellent sir
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Very very explained vedio 👍
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)
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Thanks
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Sir mere 2007 excel me formula dalne k baad b "region" ka "zone" nahi horai 🤔?... Uske instance num me kuch dalna hai kya?
Best sir
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
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
No issue Sharma ji ..Better oppertunity waiting for you
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
Sir bohot achese smzaate ho
Thanks Arjun,Hope aapko samajh aate h concept 🙏❤️ Basic Excel playlist se step by step dekhiye
Sir substitute ki aage ki video ni bnai aapne?
Matlab nhi Aaya samjh ..? Advanced substitute questions ki baat Kar re hain kya...start Karne wale hain New series for advanced formula learner
@@Innozant yes sir advance LEN substitute ye dono k advance kra do
Excellent Sir ji 👌👌👌👍
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
Thank you। so much sir 👌
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
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???
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.
Ok..Willl chacke and acknowledge
Sir agar word main three “B” hai toh sab ko alag letter se kaise change substitute main
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
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 🙏
Thank you
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Sir kisi text se pehle tick ka nishan kaise lagaye custom formatting.
Cutstom formatting se better conditional formatting use krke concatenate kr skte h symbol na
Nice💗
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
Is video ka next part ki link dijiye sir 🙏
Usi playlist me hai dear
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
Sir agar apke pass ake traning lene ke lie aye to Delhi main apka institute h kya sir
Yes.
New Ashok Nagar Delhi me.hain Innozant Institute
Hi sir agar number hai aur muzhe start me 0 aur mid 2 place pe - dalana hai replace formula use hoga
Substitute use kar lijiye
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?
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Thnq sir
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
* ko kaise replace kre
Using tilde
@@Innozant thanks sir ho gya
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
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🙏
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
@@Innozant Thanks guruji👍
Advance substitute par video banao sir
Already Kai's example Hain. Interview cracker series me..alag se BHI tips and tricks me leke aayenge videos
Ok sir
Can you tell any method to replace texts in a or multiple text boxes (inserted from Insert >Shape >Textbox) in excel. Thank you
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
is ka matalb hai aaap nay bahot zyda mehnat ki hoge starting main
off course krna hi chaise mehnat life me humen dear
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
Sir aap shf ke baad snz kiya h aur function m shf se pahle snz karke dikha rahe , why?
Aap concept dekhiye kya karaya ja rha hai . replace function ka application sikhaya ja ra hai
INZ age Aya SHF ke yeh to galat hua na
SQL kya charges hai ??
Uske liye aap innozant ke number par WhatsApp karke detail le sakte hain course related
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.
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".........
If replace word is not define or different then
Didnt get you .explain your query
How can I use substitute function to replace " sign from my text.
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Substitute or replace dono mai kya difference hai
Replace kisi text string ke andar ke kuch part ko badalke kuch aur krega jbke substitute kisi existing text string konbadalke kuch aur
Thank you sir
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 ..
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 .🙏
@@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 UA-cam ...please start VBA series too...
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
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")
Agr isme name k badle phone no alg krna hoto kya bnega formula
To right use krke len-10..yahan apka right kaam kar jayega ..apply and check it now
@@Innozant yes Len 10 se hojayega but agr ph no ki lenth alg ho to like 7 etc
sir i want to data entrywork online you know any website or plateform i confidance on you please reply to this matter sir
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
Shortcut key for replace
Control + H
Pl show in zoom
With other examples
Ravi- Shankar * Kumar how to remove -, * both
Sir kanika sharma wala example accha h but agar mere pass 20 25 name ho or sabki length alag alag ho to kaise krenge.
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
@@Innozant ohkay sir thanku
most important formula sir apsa jada UA-cam pay KO I Explain nhi nhi karta h
Thanks Karan..keep watching..learn and share with your friends group.
@@Innozant OK
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.
in time of pandemy, and "shake" excell, see here :
drive.google.com/file/d/1A6M0DQF9XSK1h_kuPp13omxXFdJdKfpt/view?usp=sharing
Instance numbers in substitute work nhi kar raha
are kyu nhi krega dear.. instance number paas krnege us position k value ko ui change krega
Dear sir...
File ka direct link de diya karo... mujhe mil nahi rahi....
His data field ko count krna hai use value field me drop kijiye
=RIGHT(A24,LEN(A24)-10) ans me right k 10 number ni aaye h ye aaye h why 18090921 plez explain
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.
@@Innozant sr mujko right k phone no alg krne h isme se to its possible or not
Sir mere *100 1+ 1- ye formula me kaise lagate he ye samjh nhi ata
Matlab Sanjay ji...ek Baar smjhaiye kya use Karna hai formula me tabhi bata paunga Aise nhi aa Ra samajh
Sir data he usme mujhe cost value nikalni he
Wo to simple formula lgega his base par calculation Hona hai.
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,
Extract number only ka video tips and tricks ke andar dekhiye ..without delimeter
=Right(text,10)
Sir mujhe mid function samjh nhi aa rha bohot try kar liya
Kyu vishal ji..step by step video dekhiye maone concept samjhaya hai..
🌟🌟🌟🌟🌟
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
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
ua-cam.com/video/2935505X3yU/v-deo.html
Saath hi video description me (Playlist i. Sequence ka link diya gya hai ki kaise start karna hai playlistwise)
Wow gajab replace ki shadi kardo substitute se to replace ban jayega,
Replace Substitute, gajab
😂😂😂😂😂
Haha..Yaad rahega aapko humesha ye example😆❤️🙏
C column ka replace formula ka ans galat aaya
Kya galat aaya ?
@@Innozant aapne C2 me INZ, SHF ke bad diya hain or formula me pahale diya hain.
@@Innozant waise jada mistake nahi hain aapne 4 space count kiye the usaki jagah our space count karne honge.
@@Innozant aapka example and explanation bahut aachha hain.
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
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 ❤️🙏
Abr replace ka example kuch hai answer kuch or hai.. chujju
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❤️
thanks a lot sir
Good explain. But thora zoom kr k explain kryn. Plz
Thanks Abdul..Sure dear zoom la dhyan rakhenge
thanks a lot sir
thanks a lot sir
thanks a lot sir
thanks a lot sir
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
thanks a lot sir
ua-cam.com/video/ft2ZodFKenI/v-deo.htmlsi=GeF8b_iufOLw6GKc
thanks a lot sir
ua-cam.com/video/mJiEBjF82cU/v-deo.htmlsi=2c4JOkPZjhWpeMsQ