Finding the final occurence of a space in a string

I'll apologize in advance if this has already been done. I did a search for "final occurence of a space in a string" and didn't see anything that matched.

I have a cell that has a string with multiple spaces.

I need to find the position of the last space.

So

AAA BB CC DD EEE FF

I need to find the value of the space between EEE and FF

Basically, a find or search function, but that searches right to left instead of left to right.

Try,

=FIND("^",SUBSTITUTE(A1," ","^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))

Or,

=LOOKUP(9E300,FIND("^",SUBSTITUTE(A1," ","^",ROW(A$1:A$1000))))