Replacing characters in cells string
 

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.

Replacing characters in cells string
 

Edit/Replace
Find What = ;;
Replace With = ;
Make sure Find Entire Cells Only is unchecked.
Replace All

Make sure you back up your data.



"Billy B" wrote:

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.