Recently a client inquired of me how to find all text within quotation marks and change the formatting to bold. Not only that, he needed the solution to handle many words within the quotation marks!
Ok, there are a couple of methods to accomplish this. Follow the steps below to learn how:
- Click CTRL + H to display the Replace tab of the Find and Replace dialog box.
- In the Find What box, key in:
- [“ | ” ] * [“ | ” ]
- You must enter the text above exactly as you see it, without spaces. I have added spaces here in order that you can clearly see what is being entered.
- The quote before the first “pipe” or vertical bar (whichever term you use for that character), Is the opening smart quotation mark and the second one is the closing smart quotation mark. If you are unsure how to enter them, you can simply hold down your Alt key and on the num pad of your keyboard click 0147 and 0148 respectively.
- Now, move to the Replace With box and click on Format | Font to display the Replace Font dialog box. You may have to click on the More button so that you can see the Format button.
- In the Font Style list, click on Bold.
- Click OK.
- Be certain the Use Wildcards check box has been selected.
- Click on Replace All.
The only other method that I am aware of is to create a macro to accomplish this, which I confess I am not very good at but luckily I know someone who is – Allen Wyatt! The macro below was created by Allen:
Thank you Allen!