Find out the last position of a character in string from right to left

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,”_”,””))))

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply