Modifying and rectifying any document with Google Sheets is just as easy as it is with Word or Excel. The web-based app by Google is able to provide every editing or searching feature you seek from it. The easy part in Google Sheet is to locate and edit out specific texts. Here is how you can do this and much more with Google Sheets.

Using the Classic Search Feature

If you want to use the classic search feature, then you need to follow the instructions given below.

• First of all, you have to go to Google Drive & launch a spreadsheet.
• Then you should navigate to the sheet option you would like to search.
• Go to the Edit option.
• Navigate to the Edit drop-down menu & choose “Find & Replace.”
• You should input the text you would like to search for.
• You have one more option, input new text in the “Replace with” box if you would like to replace the original text.
• Go to “Find.”
• Now, select Done or the “X” icon to close the search screen.

Searching for Text on Android

You need to search for text on Android, follow the steps mentioned below.

• Get started by opening Settings on your device.
• Then you should choose Apps.
• You have to select the Google sheets icon to open the application.
• Thereafter you should sign in if it doesn’t verify you automatically.