Posted inExcel Find out the last position of a character in string from right to left Posted by By admin May 30, 2019 EG: find out the last position of character '_' in text in cell A1 =FIND("|",SUBSTITUTE(A1,"_","|",LEN(A1)-LEN(SUBSTITUTE(A1,"_",""))))