Find first period from the right
 

Find first period from the right

How do I do that?
--
David P.

Find first period from the right
 

What happens when you find this said period?

Find first period from the right
 

On Wed, 10 Dec 2008 18:44:01 -0800, David P.
wrote:

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