excel retrieve last char in a string code example

Example 1: ms excel find last character in a cell

=RIGHT(A2,LEN(A2)-FIND("@",SUBSTITUTE(A2,"/","@",LEN(A2)-LEN(SUBSTITUTE(A2,"/",""))),1))

Example 2: excel find position of second to last character in a string

=FIND(CHAR(160),SUBSTITUTE(text,"@",CHAR(160),N))