EG: find out the last position of character ‘_’ in text in cell A1
=FIND(“|”,SUBSTITUTE(A1,”_”,”|”,LEN(A1)-LEN(SUBSTITUTE(A1,”_”,””))))
Posted inExcel
Find out the last position of a character in string from right to left

EG: find out the last position of character ‘_’ in text in cell A1
=FIND(“|”,SUBSTITUTE(A1,”_”,”|”,LEN(A1)-LEN(SUBSTITUTE(A1,”_”,””))))