Assuming that the string "The value of sum is" is not changing and just the number,please use mid function as shown below to extract the number from string
Code:
str="The value of sum is 88 77 88"
num=mid(str,20,len(str))
msgbox num