Excel - Using SEARCH with MID to Extract Text From a Variable Starting Point

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ต.ค. 2024

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

  • @anntruongcpambaea7693
    @anntruongcpambaea7693 6 ปีที่แล้ว +2

    Thank you very much for creating this helpful video. For the data without a space at the end, you can try the following formula: MID(A3,SEARCH(E1,A3)+LEN(E1),LEN(A3)-SEARCH(E1,A3)-(LEN(E1)+1)

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

      I knew some smart will answer, as I put a comment. Question: How do I know which is last ? say the excel and thousands of rows.

  • @cazmaj
    @cazmaj 2 ปีที่แล้ว

    Fantastic video, really useful!
    I love Excel and great contributors like yourself!

  • @Pankaj-Verma-
    @Pankaj-Verma- 4 ปีที่แล้ว

    Thank you so much for your kind help!

  • @TheOligopeptide
    @TheOligopeptide 6 ปีที่แล้ว

    You could use the iferror function to create two more cases:one where you have only two exercises and another when you have only one instead of placing a zero, right?
    Also for the last qustion could you delete the space after the search? Something like minus one after the search?

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

    Thank you thank you thank you :)

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

    Aha, this formula expects that the A column data ends with " " or the last items will fail.