Hello,
I would like to search from right to left within a cell to find the "last" position of a character. The character might appear any number of time, hence find() is not good because I can't be sure how many times it will appear.
Eg Find the position of "." if the following text were in a cell:
Hello. I'm Peter. Welcome.
How do I find the position of the third "."?
I would like to search from right to left within a cell to find the "last" position of a character. The character might appear any number of time, hence find() is not good because I can't be sure how many times it will appear.
Eg Find the position of "." if the following text were in a cell:
Hello. I'm Peter. Welcome.
How do I find the position of the third "."?