Tolong bantuannya bang, sy ingin mengambil kata tertentu ditengah2 kalimat tpi posisinya beda2
Tolong bantuannya bang, sy ingin mengambil kata tertentu ditengah2 kalimat tpi posisinya beda2
coba :
=MID(B3,FIND("#",SUBSTITUTE(B3,";","#",LEN(B3)-LEN(SUBSTITUTE(B3,";",""))))+1,LEN(B3))
Nimbrung nih:
=TRIM(RIGHT(SUBSTITUTE(TRIM(B3),";",REPT(" ",255)),255))
Terima kasih abang2