Find position of a character within the worksheet cell

[Christmas May]

If you have a cell whose contents contain a sentence of text with several
spaces, how can you find the position of the last space?

Thanks in advance,

Christmas May

 

[Christmas May]

InstrRev() function. Perhaps I should read the help files before posting!

 

[Mike H]

Try

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

As you posted in programming here's a VB solution

Lastspace = Len(Left(Range("A1"), InStrRev(Range("A1"), " ") - 1)) + 1

Mike

Mike

 

[Mike H]

Far too complicated

Lastspace = InStrRev(Range("A1"), " ")

Mike