Depends if it is fixed

[VBA]myNum = Val(Mid$(myString,4,3))[/VBA]

or if not, is there some flag character to look for.