How to clean your google analitycs reports
I found a very fast and easy method to turn a keywords reports exported from google analitycs into a clean report with your listed keywords clean from punctuation and annoying characters.
Save somewhere your report, right click and open it with Microsoft Office Front Page. From the top drop-down menu click edit and then replace.. leave blank the "Find what" box and in the "Replace with" box enter the first character you want to delete, then push the "Replace all" button. Repeat the procedure with all the other characters you want to delete until you see your reports perfectly clean. Save the work. This method saved me very much time ..maybe could be useful for you too.