It depends what you know about the string. For example, do you know what the first and third words will be? Do you know only the first word or only the third? You’ll need to use a mixture of InStr, Replace and Trim.
If neither, then you could look for the space between the words and trim everything around it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.