Find and Replace Words in Google Sheets

How to find and replace words in Google Docs Spreadsheets?

Explanation

Find and replace tool helps to find the identical words and replace all those terms with the new words.
In the below image, to replace the word Tester with the new words follow the steps given below.

Step 1:
Option 1: Press Ctrl+F. Type the word to be replaced in the search box. For replacing the word with the new word click More options.

Option 2: Edit → Find and replace... or press Ctrl+H.

Step 2: Type the word to be found in the Find search box and type the word to be replaced in the Replace with option.
Step 3: Click Find button to find the identical words and then click Replace button to replace single occurrence.

To replace all the occurrences of the word, click Replace all .

Step 4: You will get a notification message as given in the image below. Replaced all instances. Click Done to close the dialog box.

Step 5: In the below image, the word Tester is replaced by SEO.

Related Topics