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

Подписаться 148 тыс.

Просмотров 86 тыс.

50% 1

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.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#substitute#findandreplace #Innozant #excelsubstitutefunction

Опубликовано:

29 июн 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 159

@aijazabro1332 Год назад

MashaAllah. Wonderful explaination.

@Innozant Год назад

Thanks dear

@aptrends3257 2 года назад

Sir Thanku very much sir your teaching is osm osm

@rajd4739 9 месяцев назад

Very helpful video

@dpak_sharma 2 года назад

Thank you। so much sir 👌

@tt_badmash_9560 Год назад

Excellent sir

@timeclone34 Год назад

SIR U ARE TOO GOOD

@dhakafady774 Год назад

thanks a lot sir

@yashpatil3375 10 месяцев назад

Excellent Sir ji 👌👌👌👍

@RA-rh5lb Год назад

Thank you

@ChandanKumar-gp8zw 2 года назад

Thanks

@instagramreels9524 3 года назад

i became your fan sir superb 👌

@Innozant 3 года назад

Thanks 🙏❤️

@sawaimalhi8439 3 года назад

bahot he acha concept diya sir aaap nay tu

@Innozant 3 года назад

Thanks Malhi❤

@VikashKumar-vp7rv Месяц назад

Best sir

@gauravbhatia7987 3 года назад

Thnq sir

@dynasticdraculagaming8668 2 года назад

Nice💗

@Pooja-bd7zm 3 года назад

Very very explained vedio 👍

@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)

@prashanthvamsi 4 года назад

Very good teaching skills ..

@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 4 года назад

Recommend you to watch this ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7ll7yb_hdvY.html And give your feedback for the same.

@Veenu-yi7pc 3 года назад

Teaching methods are impressive and good for beginners

@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 🙏

@vishalbhati912 2 года назад

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 2 года назад

Thanks Bhati Ji .God bless you Happy learning

@mohitsharma-ym3km 3 года назад

Substitute (A1, Right (A1,10),""). For last example.

@deysub1 Год назад

Can you tell any method to replace texts in a or multiple text boxes (inserted from Insert >Shape >Textbox) in excel. Thank you

@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?

@abdulbasitminhas1149 3 года назад

Good explain. But thora zoom kr k explain kryn. Plz

@arjuntuteja5955 3 года назад

Sir bohot achese smzaate ho

@Innozant 3 года назад

Thanks Arjun,Hope aapko samajh aate h concept 🙏❤️ Basic Excel playlist se step by step dekhiye

@arjuntuteja5955 3 года назад

Sir substitute ki aage ki video ni bnai aapne?

@Innozant 3 года назад

Matlab nhi Aaya samjh ..? Advanced substitute questions ki baat Kar re hain kya...start Karne wale hain New series for advanced formula learner

@arjuntuteja5955 3 года назад

@@Innozant yes sir advance LEN substitute ye dono k advance kra do

@vimalkumar-qt2uc Год назад

sir i want to data entrywork online you know any website or plateform i confidance on you please reply to this matter sir

@johndas8173 2 года назад

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

@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 2 года назад

No issue Sharma ji ..Better oppertunity waiting for you

@harshalagrawal7495 3 года назад

How can I use substitute function to replace " sign from my text.

@tarjitmalka3978 4 года назад

🌟🌟🌟🌟🌟

@pramodbhatt6906 2 года назад

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 2 года назад

Offcourse ,We can..

@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 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 3 года назад

@@Innozant Very very thank you sir, it means a lot to me ❤️

@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 Год назад

Ok..Willl chacke and acknowledge

@bestsong340 2 месяца назад

Very nice ❤️❤️❤️

@DEADYBOYS Год назад

Sir i have idea is video me last example me right function ka use kr sakte the

@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 3 года назад

Aapne 3 char reolace kar diya...zero pass kren..phir insert krega na ki replace

@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

@chetan1008 2 года назад

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 2 года назад

Attempt bktke btaiye Chetan...

@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?

@user-jq8ej8bg2m 2 года назад

Sir kisi text se pehle tick ka nishan kaise lagaye custom formatting.

@Innozant 2 года назад

Cutstom formatting se better conditional formatting use krke concatenate kr skte h symbol na

@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

@nileshjadhav7539 2 года назад

Hi sir agar number hai aur muzhe start me 0 aur mid 2 place pe - dalana hai replace formula use hoga

@Innozant 2 года назад

Substitute use kar lijiye

@battlefansshorts8941 3 года назад

Advance substitute par video banao sir

@Innozant 3 года назад

Already Kai's example Hain. Interview cracker series me..alag se BHI tips and tricks me leke aayenge videos

@battlefansshorts8941 3 года назад

Ok sir

@VipinSingh-jv9pf 4 месяца назад

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................

@vishaltanwar8318 11 месяцев назад

Sir please make some change in your video quality because it's showing blur🙏🏻

@soniabhi8327 11 месяцев назад

Is video ka next part ki link dijiye sir 🙏

@Innozant 11 месяцев назад

Usi playlist me hai dear

@abhisheksingh398 Год назад

Sir agar apke pass ake traning lene ke lie aye to Delhi main apka institute h kya sir

@Innozant Год назад

Yes. New Ashok Nagar Delhi me.hain Innozant Institute

@sawaimalhi8439 3 года назад

is ka matalb hai aaap nay bahot zyda mehnat ki hoge starting main

@Innozant 3 года назад

off course krna hi chaise mehnat life me humen dear

@TrendingMuzic25 Год назад

Sir agar word main three “B” hai toh sab ko alag letter se kaise change substitute main

@computerorigin7434 2 года назад

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 🙏

@upendrapagare6899 2 года назад

Pl show in zoom

@TheSentu 2 года назад

Shortcut key for replace

@anuragrawat3435 Год назад

Control + H

@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

@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 4 месяца назад

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".........

@jituchablani3171 3 месяца назад

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???

@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

@rsk98 2 года назад

Ravi- Shankar * Kumar how to remove -, * both

@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

@sumitarora2526 2 года назад

If replace word is not define or different then

@Innozant 2 года назад

Didnt get you .explain your query

@AbhishekKumar-nb4et 2 года назад

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 2 года назад

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 2 года назад

@@Innozant Thanks guruji👍

@virendersroha1754 4 года назад

Agr isme name k badle phone no alg krna hoto kya bnega formula

@Innozant 4 года назад

To right use krke len-10..yahan apka right kaam kar jayega ..apply and check it now

@virendersroha1754 4 года назад

@@Innozant yes Len 10 se hojayega but agr ph no ki lenth alg ho to like 7 etc

@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 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 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 RU-vid ...please start VBA series too...

@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 3 года назад

in time of pandemy, and "shake" excell, see here : drive.google.com/file/d/1A6M0DQF9XSK1h_kuPp13omxXFdJdKfpt/view?usp=sharing

@sagarmathur3535 3 года назад

SQL kya charges hai ??

@Innozant 3 года назад

Uske liye aap innozant ke number par WhatsApp karke detail le sakte hain course related

@amitpyasi2819 2 года назад

Substitute or replace dono mai kya difference hai

@Innozant 2 года назад

Replace kisi text string ke andar ke kuch part ko badalke kuch aur krega jbke substitute kisi existing text string konbadalke kuch aur

@amitpyasi2819 2 года назад

Thank you sir

@OfficialComputerWorkTricks 2 года назад

* ko kaise replace kre

@Innozant 2 года назад

Using tilde

@OfficialComputerWorkTricks 2 года назад

@@Innozant thanks sir ho gya

@MukeshSingh-kv4pn 2 года назад

Sir aap shf ke baad snz kiya h aur function m shf se pahle snz karke dikha rahe , why?

@Innozant 2 года назад

Aap concept dekhiye kya karaya ja rha hai . replace function ka application sikhaya ja ra hai

@prathameshrane7607 7 месяцев назад

INZ age Aya SHF ke yeh to galat hua na

@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 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 4 года назад

@@Innozant ohkay sir thanku

@karankapoor200 4 года назад

most important formula sir apsa jada RU-vid pay KO I Explain nhi nhi karta h

@Innozant 4 года назад

Thanks Karan..keep watching..learn and share with your friends group.

@karankapoor200 4 года назад

@@Innozant OK

@Jitenderkumar-yp1rn 3 года назад

Dear sir... File ka direct link de diya karo... mujhe mil nahi rahi....

@Innozant 3 года назад

His data field ko count krna hai use value field me drop kijiye

@manoharjha509 8 месяцев назад

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

@neerajsingh-oz5od 3 года назад

Instance numbers in substitute work nhi kar raha

@Innozant 3 года назад

are kyu nhi krega dear.. instance number paas krnege us position k value ko ui change krega

@sanjayrathore8599 3 года назад

Sir mere *100 1+ 1- ye formula me kaise lagate he ye samjh nhi ata

@Innozant 3 года назад

Matlab Sanjay ji...ek Baar smjhaiye kya use Karna hai formula me tabhi bata paunga Aise nhi aa Ra samajh

@sanjayrathore8599 3 года назад

Sir data he usme mujhe cost value nikalni he

@Innozant 3 года назад

Wo to simple formula lgega his base par calculation Hona hai.

@vishalrajput904 3 года назад

Sir mujhe mid function samjh nhi aa rha bohot try kar liya

@Innozant 3 года назад

Kyu vishal ji..step by step video dekhiye maone concept samjhaya hai..

@virendersroha1754 4 года назад

=RIGHT(A24,LEN(A24)-10) ans me right k 10 number ni aaye h ye aaye h why 18090921 plez explain

@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 4 года назад

@@Innozant sr mujko right k phone no alg krne h isme se to its possible or not

@choudhary2033 3 года назад

Wow gajab replace ki shadi kardo substitute se to replace ban jayega, Replace Substitute, gajab 😂😂😂😂😂

@Innozant 3 года назад

Haha..Yaad rahega aapko humesha ye example😆❤️🙏

@choudhary2033 3 года назад

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 3 года назад

Extract number only ka video tips and tricks ke andar dekhiye ..without delimeter

@shouryashorts9795 3 года назад

=Right(text,10)

@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 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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2935505X3yU.html Saath hi video description me (Playlist i. Sequence ka link diya gya hai ki kaise start karna hai playlistwise)

@k.sandip6288 2 года назад

C column ka replace formula ka ans galat aaya

@Innozant 2 года назад

Kya galat aaya ?

@k.sandip6288 2 года назад

@@Innozant aapne C2 me INZ, SHF ke bad diya hain or formula me pahale diya hain.

@k.sandip6288 2 года назад

@@Innozant waise jada mistake nahi hain aapne 4 space count kiye the usaki jagah our space count karne honge.

@k.sandip6288 2 года назад

@@Innozant aapka example and explanation bahut aachha hain.

@771malik 2 года назад

Abr replace ka example kuch hai answer kuch or hai.. chujju

@Innozant 2 года назад

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❤️

@maheshkadam2838 3 года назад

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 3 года назад

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 ❤️🙏

@dhakafady774 Год назад

thanks a lot sir

@abdulbasitminhas1149 3 года назад

Good explain. But thora zoom kr k explain kryn. Plz

@Innozant 3 года назад

Thanks Abdul..Sure dear zoom la dhyan rakhenge

@dhakafady774 Год назад

thanks a lot sir

@dhakafady774 Год назад

thanks a lot sir

@dhakafady774 Год назад

thanks a lot sir