I have created a mail merge for labels and it works just fine but there is one field where I only want to grab part of the text. Most wording in this field reads like this for example: John Doe vs. Microsoft. I would like to grab only the text before the vs. In other words I only want to grab John Doe
Can this be done?
The reason I want to do this is because the line becomes too long and it moves to the next line. If I can't do the above, is there a way to automatically shrink the text so it all stays on one line?
Hope that all makes sense.