Find second dash ( - ) in a cell

[raj08536]

I can find first - in a cell by using following formula

=Find("-",A10)

how can i find the second and third?

 

[barry houdini]

How high do you want to go? For the 2nd you can use

=FIND("-",A1,FIND("-",A1)+1)

but that would get longer for 3rd or 4th

For 3rd you could use this

=FIND("^^",SUBSTITUTE(A1,"-","^^",3))

change 3 to whatever instance you need