On Sat, 22 Jul 2006 21:13:29 -0400, cooldyood
wrote:


Is there a built-in function to find the last space in a string? In
other words, I want to search within a string from right to left.

Number of Last Space:

=FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))


--ron