first space from the right

[delmac]

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

 

[Bob Phillips]

=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]

didn't work I'm afraid.
--
delmac

=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)

 

[Bob Phillips]

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]

thnaks very much Bob, it did work firts time, Iwas just to stupid to actually
copy it into the correct cell.

regards