Advanced Find & Replace | Find & Replace | Part 2

Поделиться
HTML-код
  • Опубликовано: 16 окт 2024
  • Advanced Find & Replace | Find & Replace | Part 2
    Download Practice files Click here bit.ly/2Lpjvyf
    In this tutorial, we will Find & Replace in MS Excel vs. MS Word in Detail. and you learn Advanced Find & Replace in Excel as well as Word.
    Check out our 22+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
    Find & Replace - Word vs. Excel
    Find & Replace - Any Digit
    Find & Replace - Any letter
    find & replace
    find & replace in excel
    find & replace in word
    find & replace in ms word
    find & replace all on a batch of documents in the same folder
    find/replace formatting in word 2016
    find and replace online
    find and replace the shortcut
    find and replace tool
    find and replace excel
    find and replace mac
    text editor online find replace
    find replace mechanic
    find and replace keyboard shortcut chrome
    find and replace chrome shortcut
    #Find&Replace #AdvancedFind #Exceltutorials #excelinhindi #Excelsuperstar
    To watch more videos visit: www.excelsupers...
    To Buy an Excel Course Pen drive visit: www.excelsupers...
    Like us on Facebook: / excelsuperstar
    Subscribe to the Channel: / excelsuperstar

Комментарии • 135

  • @rishabhpugalia9281
    @rishabhpugalia9281 6 лет назад +16

    Hello Everybody! Hope you were able to show off some of these skills at office. Thanks for all the love! :) #iamrishabh

    • @mdkareem6792
      @mdkareem6792 5 лет назад

      hi sir i need full advance excel pdf to practice would you provide or suggest any link. it will be a great help from your end.

    • @mudassar46
      @mudassar46 5 лет назад +1

      Hi sir, i have learnt a lot from your videos, thanks for sharing.
      is there any link to download your all lessons from youtube?

    • @tannutechsolution
      @tannutechsolution 5 лет назад

      hi sir... mere paas horizontal me data hai and ek checklist hai jiske samane jo chahiye wahi aana chahiye...
      ex.
      name
      placement
      doj
      hr no.
      etc

    • @tannutechsolution
      @tannutechsolution 5 лет назад

      aapka vlookup and match formula uss data pe work NH kar raha might be iam doing something wrong

    • @yogitashadeeja947
      @yogitashadeeja947 5 лет назад

      Sir your vedios are the best for the purposes of understanding logic behind everything in excel..
      Can I have your no. for having my queries resolved

  • @sunainamisal4371
    @sunainamisal4371 6 лет назад

    Hello sir..ap itne ache se explain krte h ..or itne pyar se smjhate h ...ki bss aisa laga hai apke hi video dekhte hi rho or apki voice to bht hi sunder hai....

  • @atulshukal4072
    @atulshukal4072 3 года назад

    बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब

  • @thedoc1733
    @thedoc1733 6 лет назад

    Wow, jab apke videos dekhta hu tab lagta h excel ka bas kuch hi knowledge h mare pass,, excellent Reshav bhai

  • @MrPZAHOOR
    @MrPZAHOOR 4 года назад

    wah rishab sir wah. Gazab ka class tha

  • @basis_tech4555
    @basis_tech4555 5 лет назад +2

    Dost ye find replace Ke tricks bahot zabardast hai... lots of love from this gabru Jawan,,,☺️👍👌

  • @viralpunjab3746
    @viralpunjab3746 5 лет назад

    very gud find & replace option mujhe kya mere pure department ko bhi ni pta tha iske bare mein thanx rishab sir

  • @Success_Mantra82
    @Success_Mantra82 4 года назад

    *आपकी विडियो बहुत अच्छी लगी.! Excel Superstar* ❤️❤️🤗

  • @sunainamisal4371
    @sunainamisal4371 6 лет назад

    Maine apka video dekhne k bad VLOOKUP formula lagana sikha h ...thanku sir ...

  • @mdsajjadsaleem6992
    @mdsajjadsaleem6992 5 лет назад

    Amazing birrliyant supper trick both are very useful and still waiting for next part

  • @zainsulehri5964
    @zainsulehri5964 3 года назад

    Informative and great video i ever seend ... Love from pakistan 😍😍

  • @123mailashish
    @123mailashish 6 лет назад +1

    i m short of words in praising u!!!
    keep it up...all b best wishes to u!!!

  • @anilsodhi9078
    @anilsodhi9078 6 лет назад

    Whoooo bohat badiya tricks he bro terrific word kam he aap ke liye you are extraordinary 🤗🤗🤗✌️✌️👌👌👌👍

  • @aiyazlakhani
    @aiyazlakhani 6 лет назад

    Awesome sir. You make us excel super star. Thanks

  • @deepakmodi4699
    @deepakmodi4699 5 лет назад

    Sir your work is really great .....
    Thanks for sharing these tips&tricks with us...
    Love from jaipur

  • @piyushlife99
    @piyushlife99 6 лет назад

    Awesome Trick Rishabh ji...

  • @PankajYadav-bv4hd
    @PankajYadav-bv4hd 5 лет назад

    Rishabh you are simply superb !!!!

  • @VIJAYKUMAR-xr7nx
    @VIJAYKUMAR-xr7nx 6 лет назад

    सर आपका विडियो देख कर मै एक्सेल सीक रहा हू।
    Thanks Sir.

  • @madangoud9078
    @madangoud9078 4 года назад

    lively explanation rishab. keep it up

  • @keyexplorer
    @keyexplorer 5 лет назад +2

    You rock dude
    continue the knowledge sharing
    May Lord Vishnu bless u with happiness..😊👍

  • @frankalphanso2508
    @frankalphanso2508 5 лет назад

    Sir, you are one of the excellent teachers.

  • @handsomeboy7194
    @handsomeboy7194 6 лет назад

    matchless video ....... thanks Sir for sharing with us

  • @harishpaldhir5915
    @harishpaldhir5915 6 лет назад

    Mind blowing sir ji 😇😇😇😇

  • @hindstudypoint
    @hindstudypoint 6 лет назад

    बहुत अच्छा

  • @magbulmansuri4636
    @magbulmansuri4636 5 лет назад

    VERY NICE INFORMATION

  • @bipingaonkar6243
    @bipingaonkar6243 6 лет назад

    Salute Sir, excellent. Very useful vedio.

  • @Dev_Bartwal
    @Dev_Bartwal 6 лет назад

    Very Useful Sir.. Thanks to sahring with us. I love it

  • @Moraskiran
    @Moraskiran 6 лет назад

    Thank you so much sir, I love your videos. Very simple and very easy to learn

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

    Outstanding vedio

  • @anchalrajput6798
    @anchalrajput6798 6 лет назад

    Sir please aap 2007 main use hone wale trick bhi bataye. Aapki sabhi video bohot useful hain humare liye

  • @saikatbhowal1474
    @saikatbhowal1474 5 лет назад

    Very usefull video sir

  • @noorqamar7580
    @noorqamar7580 6 лет назад

    you are great sir G amazing topics always

  • @ajitsinghbisht4233
    @ajitsinghbisht4233 6 лет назад

    awesome sir.. thanks

  • @jyotiloomba464
    @jyotiloomba464 4 года назад

    That's awesome tricks

  • @saurbhsingh6907
    @saurbhsingh6907 6 лет назад

    great, you have done awesome work for us

  • @sunilrkvlogs964.
    @sunilrkvlogs964. 6 лет назад

    Sir u r the best keep it up sir

  • @pankajsaini50
    @pankajsaini50 Год назад

    Great Sir

  • @123mailashish
    @123mailashish 6 лет назад

    dude...u r rocking!!!
    shot n crisp......

  • @vaibhavkhaire7014
    @vaibhavkhaire7014 4 года назад

    Sir aap right corner me link provide nahi karte. It's really useful. And no offense for the knowledge u gives its awesome 👍

  • @lakhankushwah1338
    @lakhankushwah1338 4 года назад

    Very nice sir

  • @yashrajinn
    @yashrajinn 5 лет назад

    Very nice explain sir thank you

  • @ndcisurajsir2018
    @ndcisurajsir2018 6 лет назад

    Sir very good video

  • @banglatechhotspot2235
    @banglatechhotspot2235 5 лет назад

    Thanks for helpful tutorial

  • @mudassar46
    @mudassar46 5 лет назад

    Hi sir, i have learnt a lot from your videos, thanks for sharing.
    is there any link to download your all lessons from youtube?

  • @akashparthe1399
    @akashparthe1399 4 года назад

    1 No Sir

  • @akshaykhadpe9410
    @akshaykhadpe9410 5 лет назад

    Sach me Super ho

  • @nidhimetha2891
    @nidhimetha2891 4 года назад

    very useful video

  • @DeepakKumarSinha_dj
    @DeepakKumarSinha_dj 5 лет назад +1

    Awesome

  • @AvinashYadav-ne6gi
    @AvinashYadav-ne6gi 6 лет назад

    Risab sir gazab hai

  • @puneetvij8433
    @puneetvij8433 6 лет назад

    Rishabh Sir,
    Boss!....Please continue. ; )

  • @MithleshKumar-qf3hk
    @MithleshKumar-qf3hk 6 лет назад

    Thanks sirji very very important vedeo

  • @PRIYANKABAGRI1991
    @PRIYANKABAGRI1991 6 лет назад

    Super as usual!

  • @aayushsinghalvins7814
    @aayushsinghalvins7814 6 лет назад +2

    Thanks for advanced tricks sir 👌👌👌

  • @devendrabairagi9461
    @devendrabairagi9461 6 лет назад

    Thank u as always,Sir

  • @vickygarg394
    @vickygarg394 2 года назад

    sir innozant ne aap ka video copy kiya ha ya aap ne innozant ka. both use same trick. plz reply

  • @paraggohel4965
    @paraggohel4965 6 лет назад

    Very useful.sir.....

  • @ANKEMADANMOHAN
    @ANKEMADANMOHAN Год назад

    Sir, Good Morning. Thanks for your sharing valuable information. I am having one problem relating to the replacing of one digit in a big data numbers. ex:- 150234, 150263, 150452 like that... I want to replace the second digit with 6. i.e., 160234, 160235 etc., Can you please share the trick or method to replace the single digit. Thank you.

  • @amansaini408
    @amansaini408 5 лет назад

    Suprb.....bro

  • @syedikramullah1114
    @syedikramullah1114 3 года назад

    Word k replace more option pr ek video banao plz

  • @deepsaha980
    @deepsaha980 3 года назад

    Thank u 😊

  • @amitrajoria4087
    @amitrajoria4087 6 лет назад

    Sir your video is very beneficial for me,
    Plz tell me how to increased 5000 in all value of a selected coulum in excel, there is so many value and I want 5000 add in all value same time,
    Plz help
    Thanks

  • @Itssagaruniverse
    @Itssagaruniverse 6 лет назад

    Thanks🙏🙇

  • @Malkava24
    @Malkava24 3 года назад

    Thanks.

  • @Madhutatipamula
    @Madhutatipamula 3 года назад

    Hi Sir, pls explain for the bank statement transaction details How to split only transaction nbr for reconciliation purpose Sir

  • @KamalKumar-wn4mn
    @KamalKumar-wn4mn 6 лет назад

    Thanks

  • @dharmendrayadav-bw2gp
    @dharmendrayadav-bw2gp 6 лет назад

    Nice video Sir.
    Sir i have a deta tabl and some blank cell in the table and want fill blank cell by different date,different tex or number. Please guide sir.

  • @sportsyard
    @sportsyard 4 года назад

    Bro pura cell udana h jisme wo word h kaise krenge

  • @virendrashah1647
    @virendrashah1647 6 лет назад

    Simply amazing. You are really "EXCEL SUPERSTAR".

  • @anilkumar-pg2hi
    @anilkumar-pg2hi 6 лет назад

    Great

  • @vinay103
    @vinay103 5 лет назад

    Waaaaaw

  • @bkstudio1714
    @bkstudio1714 4 года назад

    How to search with two words in excel?
    For example, I have a big workbook of daily production report with more than 400 work sheets and I want to search one customer name and one product in a single go from the entire workbook.
    Can you please help me?

  • @mdkareem6792
    @mdkareem6792 5 лет назад

    hi sir i need full advance excel pdf to practice would you provide or suggest any link. it will be a great help from your end.

  • @shivashankargaikwad8001
    @shivashankargaikwad8001 4 года назад

    Hello Sir
    Can you help me with shifting words to next line via replace any , or - to next line...
    Thanks in advance

  • @rohitsachdeva4285
    @rohitsachdeva4285 6 лет назад

    It's really useful trick during Data cleaning .... ✌️✌️✌️Thanku so much sir.....

  • @nirupammishra7434
    @nirupammishra7434 3 года назад

    Osm❤️

  • @shivkumar-mh5gx
    @shivkumar-mh5gx 6 лет назад

    Wah guruji

  • @Balwan_Singh
    @Balwan_Singh 4 года назад +1

    For example ABC/123 is my invoice number and I want to add FY 20-21 (ABC/123/20-21) so how to do it?

  • @learnmore1760
    @learnmore1760 2 года назад

    Thinks sir

  • @BLACK-hl4ic
    @BLACK-hl4ic 5 лет назад

    I am *Excel Little Star*
    Paste special shortcut 👍👍👍👍👍👍👍
    Ctrl+E 👍👍👍👍👍👍👍👍

  • @gautamjena7559
    @gautamjena7559 4 года назад

    Sir agar hame - ke jagah / replace karni hai toh jaise ki hum date mai karte hai dd/mm/yyyy

  • @paraggohel4965
    @paraggohel4965 6 лет назад

    Jakass sir 😎😎😎😎😎

  • @RajanikantaSit
    @RajanikantaSit 6 лет назад

    Wow

  • @VIJAYKUMAR-xr7nx
    @VIJAYKUMAR-xr7nx 6 лет назад

    Sir Private table suroo say pura sikna hai

  • @poonamakshit4920
    @poonamakshit4920 4 года назад

    Sir aapne three idiots movie ka example diya, lekin agr hum chahe ki hmari absence me hmare kaam me koyi change ho to pta lg jaye, uske baare me btaye plzzzzzz

  • @salimsiddiqui3126
    @salimsiddiqui3126 4 года назад

    Sir replace ka koi aisa logic btao jiske andar paragraph main sirf ek hi naam show kare.... Like 1 question-vishal is going to sirf isme sirf vishal hi rhe Or baki sara hatt jaye... 2 question Is vishal going to yha pr hi sirf vishal hi dikhayi de Or baki sara hatt jaye... Sir please reply

  • @sudhakarprajapati6916
    @sudhakarprajapati6916 4 года назад

    sir part 3 kab ayega

  • @mayursheliya5295
    @mayursheliya5295 2 года назад

    I Have A Some Question how to Connet

  • @Pritam5016
    @Pritam5016 6 лет назад

    Hi...excel expert
    I need a help...I stuck here
    I want to count something "AA".... if I want to count "AA" in a row if "AA" in continue in a row then use count if, if some other word in same row like "BB" then again "AA" then start count after "BB" . It means if any word comes between "AA" start again to count after new word. For example......
    Row=A 1 to E1 ''AA" then result show 5 if Row=F1 " BB" and again Row=G1 to J1 "AA" then result 4 ( start to count "AA" from G1) Thanks🙏

  • @brightfuture8584
    @brightfuture8584 Год назад

    Sir part 3 nahi mil raha please share part 3

  • @maheshyadav7455
    @maheshyadav7455 6 лет назад

    Sir 2016 excel me copy karne ke bad jo cell ke Charo taraf ghumta hai mere excel me nai Ho raha please guide me

  • @SanviPatil2019
    @SanviPatil2019 6 лет назад

    Rishbh sir kya hum ( -) is braket me minus character hai uske left ya right wale word remove kar sakte hai..find and replace se....
    Example UTR-201986537884901- DNSP101NMS05191
    Mujhe sirf yeh DNSP101NMS05191 YEH RAKHANA HAI... UTR NO AUTOMATICALLY REMOVE HO JAYE FIND AND REPLACE SE KYA HUM KAR SAKTE HAI...

  • @IrfanAli-mu3wg
    @IrfanAli-mu3wg 5 лет назад

    sir apne kaha last space se delete kia jaye first se kiosk nahe. to isme kia logic hai

  • @mohammadrain7592
    @mohammadrain7592 3 года назад

    Hi, Good Morning Sir, agr date 1.June.2021 se 30.June.2021 tak hai total 30 cell me or mai sirf June ko Hata k july Replace karna chahta hu Pls

  • @piyushbhaivekariya370
    @piyushbhaivekariya370 Год назад

    Rishabh please VBA code par vidio

  • @shivashankargaikwad8001
    @shivashankargaikwad8001 4 года назад

    For example KB123 - KB234 - KB345 in one line I want your help to replace this to
    KB123
    KB234
    KB345

  • @sahdevsori5027
    @sahdevsori5027 3 года назад

    Sir lat/long_ 18.253656* ,81.452654* me mujhe * symbol ko remove Krna h
    Kaise Kru??

  • @TravelAdventure-India
    @TravelAdventure-India 2 года назад

    Hello Sir, How r u ?

  • @anjummalka3858
    @anjummalka3858 5 лет назад

    - Ko replace/ kaise karenge

  • @Balwan_Singh
    @Balwan_Singh 3 года назад

    Pls explain how to replace ABC/1234 with ABC/1234/19-20

    • @ankursharma6157
      @ankursharma6157 3 года назад +1

      Step 1) Add a Helper Column.
      Step 2) In helper column, in all cells, write 19-20.
      Step 3) In a New Column, use & to combine ABC/1234 and 19-20.
      & का इस्तेमाल समझने के लिए ये Video देखिये: ruclips.net/video/2rPLtWyggMQ/видео.html
      Hope, this helps.

  • @SandeepRawat-zn7ov
    @SandeepRawat-zn7ov 5 лет назад

    Part 3