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.
replace data google spreadsheet
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.
find replace google sheet
Option 2: EditFind and replace... or press Ctrl+H.
find google spreadsheet
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.
replace data google spreadsheet1
To replace all the occurrences of the word, click Replace all .
replace data google spreadsheet2
Step 4: You will get a notification message as given in the image below. Replaced all instances. Click Done to close the dialog box.
replace data google spreadsheet3
Step 5: In the below image, the word Tester is replaced by SEO.
replace data google spreadsheet4


Related Topics

Google Docs Spreadsheet Tutorial