Find Function

[katmando]

Is there a function similar to the find function in excel which will return the starting postion of a charcter in a string and allow you to set the position for seaching
IE
I want to know at what postion the second ":" starts at in the following string

:UNIONSTREET.GLA:2003100

 

[RuralGuy]

Look in VBA help for the Instr() function.