Sub Splitter(byval Source as string,byref LeftValue as string, Rightvalue as long) Dim C as string, i as long,RV as string i = Len(Source) RV = "" Do C = Mid$(Source,i,1) If IsNumeric(C) Then RV = C & RV Else Exit Do End If i=i-1 Loop Until i=0 LeftValue = left$(Source,i) RightValue = cLng(RV) End Sub