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!
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!