excel find position of second to last character in a string 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))