Well I just put your example into E1, added the formula, and it returned 19.
Looks like it worked to me.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"delmac" wrote in message
...
didn't work I'm afraid.
--
delmac


"Bob Phillips" wrote:

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

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"delmac" wrote in message
...
Hi all, I'm trying to find the 1st space from the right of a sow of
strings
of different lengths. for e.g. a row might be " mr smith 2 arcadia la".

thanks again all
--
delmac