=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