Ok great ...
Now, how do you modify that to find the SECOND space from the right?

--
Thanks for your reply & assistance.
Jimbo213


"Rick Rothstein" wrote:

Here is yet another way...

=LEN(A1)-LEN(TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)))

--
Rick (MVP - Excel)


"Jimbo213" wrote in message
...

I found a Jan 5 2009 post to find the FIRST space from the right using the
InStrRev function. I'd like to incorporate this in a cell's formula, not
a
VBA function.

Is that possible?

--
Thanks for your reply & assistance.
Jimbo213