is there a formula I can use to locate the possition of a certain character in a cell.
Assume cell A1 has the following text "The tiny elephant"
- The location of the last "space" is = 9
- The location of the second "T" is =5
I would appreciate any help on this.