Function StripLastNumberFromString (cinstr as String, lim as integer) as String
dim a as integer
dim curchar as string
dim tempval as string
for a = 1 to len(cinstr)
curchar = mid$(cinstr, len(cinstr)-a+1,1)
if isnumeric(curchar) then
tempval = curchar + tempval
else
if (tempval <> "") then
exit for
end if
end if
next
StripLastNumberFromString = cStr(cLng(Right(tempval, lim)))
end Function
