EG: find out the last position of character ‘_’ in text in cell A1 =FIND(“|”,SUBSTITUTE(A1,”_”,”|”,LEN(A1)-LEN(SUBSTITUTE(A1,”_”,””))))
Read moreFind 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,”_”,””))))
Read more