is there a formula I can use to locate the possition of a certain character in a cell.
Eg.
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.
Thanks,
Rennie
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
=SEARCH(B1,A1)
=SEARCH(B1,A1,SEARCH(B1,A1)+1)
HTH
:guitar:
Don’t have an account yet? Register yourself now and be a part of our community!
