first space from the right

  • Thread starter Thread starter delmac
  • Start date Start date
D

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
 
=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)
 
didn't work I'm afraid.
--
delmac


Bob Phillips said:
=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)
Click to expand...
 
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)
 
thnaks very much Bob, it did work firts time, Iwas just to stupid to actually
copy it into the correct cell.

regards
 
Back
Top