Use the MID and FIND Functions to Extract Text Characters

Поделиться
HTML-код
  • Опубликовано: 19 янв 2025

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

  • @neilrobson8509
    @neilrobson8509 2 года назад +5

    Exactly what I needed

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

    so how would you go back and remove the year from the film title cell. for having a clean table of data.

  • @ravilifestylevlogs8496
    @ravilifestylevlogs8496 2 года назад +1

    It was a great help sir, thanks 👍🙏

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

    Thank you very much for the great video!!

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

      You're welcome, Leon. Thank you.

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

    how about MID Function vba or extract text from Notepad?

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

      To extract text from a Notepad document would be a task beyond this comment box

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

      @@Computergaga can you make sample VBA that can extract specific text from notepad? To be post here in YT?

  • @mariamayo-salam6353
    @mariamayo-salam6353 Год назад

    Nice video, i need to understand why the +1

    • @bLue_fountain
      @bLue_fountain 12 дней назад

      To remove the space before the (

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

    Hi, thanks for the video what formula can I use if the number of cararters inside the brakets is 5,6 or 7 for example, I mean if potentially numbers change?

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

      This video will help extract characters between two characters - ruclips.net/video/Yf-aqzuuQzE/видео.html
      Also there is Flash Fill and Power Query which can handle it with different advantages and disadvantages.

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

    wouldnt it have been easier to use the *right* function instead?

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

      Sure. We could have used the RIGHT function to provide MID with the text instead of FIND. We couldn't use it alone as we want to avoid the brackets.

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

    Hi I have #hameed# special meeting %xxxxx_ how should I find special meeting and after %

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

    Chandrapal tomar vocit 119064