Find third Position

[mohan.r1980]

Hello Friends,

How can i find 3rd position of "M" in find formula.
e.g.

A1="ManMenMinMax"

B1=Find("M",A1)

above formula shows me 1 result which is first "M" Position indicates
how do i find third "M" Position???

Pls suggest me

[sktneer]

One to to achieve that is

Please Login or Register  to view this content.

Hope that helps.

[hemesh]

Hello Mohan Try this in b1
=FIND("@",SUBSTITUTE(A1,"M","@",3))


Or You could use nested Find
=FIND("M",A1,FIND("M",A1,FIND("M",A1)+1)+1)