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:
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
Zoho DataPrep 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 ...FIND
Returns the position of a text string (first occurrence) within another given text string. Syntax FIND(find_text; text_to_search; [start_position]) find_text: Text string whose position you want to obtain. E.g. "S" text_to_search: Text to search ...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 remove data inconsistencies
1. Click on the Data menu. 2. From the Data Cleaning option, select Fix Data Inconsistencies from the drop down. 3. In the data cleaning panel, choose a column from which you want the tool to pick the inconsistencies from. 4. The tool will list down ...Find and replace values in a spreadsheet
To find and replace values in your spreadsheet: Go to the ... icon, then choose Find and Replace. Enter a value to search in the current worksheet. Navigate between the found values using the icons. Tap the icon to customize the search and to ...