Overview
You can use find and replace in a sheet to search for text and replace it with something else. If you need to change a client’s name in your sheet, you can use find and replace to do this.
Steps
In the sheet, navigate to Utilities > Find and replace text.
For “text to find”, enter the text that should be changed. For “text to replace”, enter the text that matches should be replaced with.
This tool will not replace text within Controls, Requests or Tasks.
You cannot replace text within Shared Columns. For the text in a shared column to be updated, you'll need to replace and edit the text on the original sheet that owns that column.