Locating the possition of a character in a cell

  • 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.



  • assuming your text is in A1 and the element you want to search for is in B1 then the first formula will find the first occurance the second formula will find the second occurance





    There are three types of people in this world.
    Those who can count and those who can't.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!