Install the Remove Duplicates add-on from the Google Workspace Marketplace. In your sheet, click Extensions, then Remove Duplicates, and choose: Find Duplicates or Uniques.

This is how you can find and replace Text in Notepad on Windows 11/10. You can even replace multiple texts at once in Notepad by following this trick.