Archive for 4 May, 2016
Excel – Search for a character from the right
I want to extract “12C2” in string “D_CI-CC____-MY-12C2”
(1) Find position of “-” from the right: MATCH(“-“,INDEX(MID(A1,LEN(A1)-ROW(INDIRECT(“1:”&LEN(A1)))+1,1),0),0)
(2) Extract “12C2”: =RIGHT(A1, MATCH(“-“,INDEX(MID(A1,LEN(A1)-ROW(INDIRECT(“1:”&LEN(A1)))+1,1),0),0)-1)
.::. 