Excel: Find character counting from the right

I know I've seen this done but for the life of me can't figure it out. I want to find the first space in a text string (in a cell) counting from the right. ie.... in Cell A1 I have "now is the time" I want a formula to tell me that the first space from the right is at position 5. Thanks!

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of April 30, 2017.

For more resources for Microsoft Excel