I need to seach all cells in Sheets(2) and replace any ;; character with ;
that may be present in the text of each cell.

I haven't the faintest idea how to do this.

Thank you.