Microsoft tends to be pretty good about having an "index" or "search" function where you can search for a string at a certain position. So, if you want the third string, search for the first space, ...

Make life easier for your Access users by building a parameter query that lets them search for specific text. Instead of fumbling around with wildcard characters, they can just enter the search string ...