Is this Access or Excel?
As I think Bob's answer is an Excel equation.
It can be found quite easily using VBA using the instring function or by parsing the whole data a pair od characters at a time.
You can also Left, Right and Mid string functions to get the whole 10 characters.
I have posted a few versions of old fashioned BASIC use, on is the post pinned to the top of the Forum.