Get first word or get LEFT word in Excel - 2 Minute Excel Formula

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ส.ค. 2024
  • Extract the first word in excel - Excel formulas and functions tutorial
    2 MINUTE EXCEL FORMULA PLAYLIST:
    • Add Months & Years in ...
    Video File location:
    www.etsy.com/a...
    The EXCEL - EXTRACT series playlist
    • EXCEL - Extract ANY wo...
    Extract First word, second word, Nth Word, Last word from a string in EXCEL:
    • EXCEL - Extract ANY wo...
    Other 2 minute Formula Videos:
    Get Last Word - www.youtube.co....
    If (contains) - • Excel If formula - If ...
    Multiple If Statements - www.youtube.co....
    Sumif and Sumifs - www.youtube.co....
    Countif and Countifs - www.youtube.co....
    rank and rank unique - www.youtube.co....
    Download the Excel Formula and File here: www.etsy.com/a...
    GET FIRST WORD FILE:
    drive.google.c...
    Excel formula tutorial on how to get the first word, using
    - left formula in excel
    - find formula in excel
    beginner excel formula and functions tutorial
    learn how to use the left formula in excel
    learn how to use the find formula in excel
    #extractfirstword
    #getfirstwordexcel

ความคิดเห็น • 13

  • @datauntelligence
    @datauntelligence  3 ปีที่แล้ว +1

    What do you think of the '2 Minute Excel Formula' videos?

    • @preetthee
      @preetthee 3 ปีที่แล้ว

      Really helpful.

  • @tompetrac
    @tompetrac ปีที่แล้ว

    Hi, awesome! PROBLEM: start number I type 1 and it doesn't work, error every time... in formula...

  • @2050somar
    @2050somar ปีที่แล้ว

    many thaks for your kind help

    • @datauntelligence
      @datauntelligence  ปีที่แล้ว +1

      Glad that my little trick was able to help.

    • @2050somar
      @2050somar ปีที่แล้ว

      @@datauntelligence thank you again & have a great time

  • @romanii1368
    @romanii1368 ปีที่แล้ว

    Amazing!

  • @user-wv3vu5gw9q
    @user-wv3vu5gw9q 2 ปีที่แล้ว +1

    Instead of the dash what if there is a number

  • @preetthee
    @preetthee 3 ปีที่แล้ว

    Now how can I remove the 1st column without making any changes to the others?

    • @datauntelligence
      @datauntelligence  3 ปีที่แล้ว +1

      Copy the new columns, right click, paste special, and paste values only. Now the formula is gone snd you can delete the original.

  • @samuelkusnierik3702
    @samuelkusnierik3702 ปีที่แล้ว

    Nefunguje to (slovak language)

    • @datauntelligence
      @datauntelligence  ปีที่แล้ว

      ha ha, funguje to dobre. prosím skúste znova