Copying random length part of the string.

[Saket]

alternately, you can take trim your value upto the first space(" ") in string

Code:

str = "Change page: < 1 2 3 4 5 6 7 8 9 10 ... > | Displaying page 1 of 426, items 1 to 10 of 4257."
num = mid(str,instrrev(str," "),len(str)-1)
msgbox num

---

correction - you can take trim your value upto the first space(" ") in string from last