Find & Replace

Google Sheets also supports find and replace operations.

Click Find and replace under the Edit menu tab.

Google Sheets gives you options to match by case or for an entire cell’s contents. You can also search using regular expressions.

• To learn more: “Find and replace items using regular expressions,” Google Docs Support

Click on the Search drop-down menu to see additional options for searching in Google Sheets.