Situatie
This is a method on replacing the text in Google sheets.
Solutie
Open Edit in the menu and select Find and Replace.
When the dialog box appears, enter the text you want to replace in the Find field and the new text you want in the Replace With field.
Next to Search, use the drop-down box to select where you want to find and replace. You can choose All Sheets, This Sheet, or Specific Range.
If you want to review each case before you replace the text, click Find and then Replace. To substitute all text immediately, click Replace All.
Leave A Comment?