Bulk Find and Replace Macro for Google Ads Keywords
by Keenan Townsend

A tool like this would be helpful when you are trying to remove special characters from your content and replace them with the standard character.

The first step would be to enter the content that you want changed in the “Original Content” sheet:

Next, you would map out the values you want changed and what you want them changed to on the “Mapping” sheet:

Finally simply press the “Replace Values” button and the macro tool will perform your find and replace request. Look at the “OutPut” sheet and voilà, you have your updated values:

Find&ReplaceMacro.xlsb