My intent here is to modify the existing 5 characters on the worksheet such as (“, ‘, —,”, ’) into a desired format (commas here are not part of the issue and are just for separation). The reason behind that is when the worksheet is loaded to Oracle tables, they are not recognized as they are and Oracle shows them with question mark as it doesn’t know how to interpret them. I have been manually replacing text with question marks and converting them to right characters like (",',-,",') that Oracle recognizes. On this worksheet located on the attached file I came up with a macro (basically a compilation of recorded macros) that replaces wrong characters with the right ones as listed. The tab "TestContents" has this problem and it is the original (unfixed) data . On the "FixedContents" tab I copy from the “TestContents” tab to see the impact of the macro. When I click on the blue box which is assigned to “SpecialCharacterFix” macro on the "FixedContents" tab (with “Fix the special character issues” text) the conversion is completed. This macro is doing what it needs to be doing and I have no problem with that. My question is how to create an Add-On doing what this macro does and obviously it needs to be more elaborate for the VBA part than what I have here like having variables and inserting the right characters for the wrong ones that are defined in the code. My macro makes the replacements by looking at the range Y1:Y5 to get the desired format on "FixedContents" tab then go back to the range on the same tab to complete the planned replacements. “Reference” tab shows the desired format for the characters under the title “Good” and undesired ones under the title “Bad”. On the "FixedContents" tab I have the same charater list in E1:E5 and F1:F5 that I use this range as my indicator after running macro to see the results immediately for the conversion.