Find first period from the right
How do I do that?
=FIND(CHAR(1),SUBSTITUTE(A1,".",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,".",""))))
It will return an error if there are no periods in the string; otherwise it
will return the position of the first period from the right (last period).
--ron
