Mengambil data tertentu

  1. 3 minggu lalu

    Tolong bantuannya bang, sy ingin mengambil kata tertentu ditengah2 kalimat tpi posisinya beda2

    Nimbrung nih:

    =TRIM(RIGHT(SUBSTITUTE(TRIM(B3),";",REPT(" ",255)),255))

  2. @Sanrawijaya

    coba :

    =MID(B3,FIND("#",SUBSTITUTE(B3,";","#",LEN(B3)-LEN(SUBSTITUTE(B3,";",""))))+1,LEN(B3))

  3. Azumi

    Jul 20 Jawaban Terpilih + 1.750 Poin

    Nimbrung nih:

    =TRIM(RIGHT(SUBSTITUTE(TRIM(B3),";",REPT(" ",255)),255))

  4. Terima kasih abang2

 

atau Mendaftar untuk ikut berdiskusi!