find last occurrence of character in string excel code example
Example: excel find position of second to last character in a string
=FIND(CHAR(160),SUBSTITUTE(text,"@",CHAR(160),N))
=FIND(CHAR(160),SUBSTITUTE(text,"@",CHAR(160),N))