Post date: Oct 08, 2018 2:21:38 PM
Example Data:
Withholding Tax - Sinar Mas Land Plaza - 000024/INV/BREEZE/11/2017 /1
want to separate the last data after "-"
Alternatif 1
=RIGHT(A2,(MATCH("-",INDEX(MID(A2,LEN(A2)-ROW(INDIRECT("1:"&LEN(A2)))+1,1),0),0))-2)
Alternatif 2
=MID(A2,(FIND("|",SUBSTITUTE(A2,"-","|",LEN(A2)-LEN(SUBSTITUTE(A2,"-","")))))+2,LEN(A2)-(FIND("|",SUBSTITUTE(A2,"-","|",LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))))))