Find and replace data
1. Click on the Search bar on the right top corner.
2. Click on the drop down menu in the search bar, and from there choose More options.
3. Once this done, a Find and replace dialogue box will appear.
4. In the dialogue box, key in the word you are looking to find and replace, and then the word you want it to be replaced with.
5. Check whether you want this replacement to be done only a Row, Column, Range of cells, a single sheet or throughout the spreadsheet.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Find and replace data
To find particular data and replace it with another: Go to Home in the menu bar and tap Find & Select. Enter the data you wish to find in the sheet and tap Find. To find and replace the data, enter the actual data and the data to replace it with. You ...REPLACE
Replaces part of a text string with another given text string. Syntax REPLACE(original_text; start_position; length; new_text) original_text: The text, part of which you want to replace. E.g. "Mick Foyd" start_position: The position where the ...Find and replace
To find and replace data: Go to Home > Search Select Find from the contextual menu. Enter the text you wish to find in the input field. Choose if you wish to search within a sheet, range or the entire spreadsheet, and click Find. Once the results ...Find and replace
To find and replace data: Go to Home > Search Select Find from the contextual menu. Enter the text you wish to find in the input field. Choose if you wish to search within a sheet, range or the entire spreadsheet, and click Find. Once the results ...Find and replace
To find and replace data: Go to Home > Search Select Find from the contextual menu. Enter the text you wish to find in the input field. Choose if you wish to search within a sheet, range or the entire spreadsheet, and click Find. Once the results ...