A useful method when performing data cleansing is simply “Find and Replace”.

Working example:

1. From the toolbar select Edit > Replace… (or press CTRL + H)
2. Enter the find and replace characters (the default is not case sensitive, if you require this click options)



3. Click “Replace All” (if some are not to be changed click just find next and replace one by one).