.::.

Excel – Search for a character from the right

4 May, 2016 at 9:49 am Leave a comment

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)

Entry filed under: IT/Soft.