The bulk find and replace macro is very helpful when you are trying to remove special characters from your content and replace them with a standard character.
The first step is to enter the content that you would like to change in the “Original Content” tab of the sheet:
Next, you need to map out the values you want changed and what you want them changed to on the “Mapping” tab of the sheet:
Finally, simply press the “Replace Values” button and the macro will perform your find and replace request. Look at the “OutPut” tab of the sheet and voilà, you have your updated values: