Find and replace values in spreadsheet | Zoho Sheet for iOS

Find and replace values in a spreadsheet

To find and replace values in your spreadsheet:
  1. Go to the ... icon, then choose Find and Replace.
  2. Enter a value to search in the current worksheet. Navigate between the found values using the  icons.
  3. Tap the  icon to customize the search and to perform replace.
  4. On selecting Replace, enter the value to find and to replace with, and tap Replace.



    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 CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now





              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 CRM Training

                  Zoho SalesIQ Resources



                      Zoho TeamInbox Resources




                                Zoho DataPrep Resources

                                  Zoho DataPrep Demo

                                  Get a personalized demo or POC

                                  REGISTER NOW


                                    Design. Discuss. Deliver.

                                    Create visually engaging stories with Zoho Show.

                                    Get Started Now











                                                          • Related Articles

                                                          • 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 ...
                                                          • 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 ...
                                                          • 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 ...
                                                          • Locate your spreadsheet's Resource ID

                                                            A Resource ID, or an RID of the spreadsheet is an alphanumeric string that forms part of the spreadsheet's URL. The RID always follows the 'open/' part of the URL. For instance, in this URL,  ...
                                                          • Share spreadsheet for collaboration

                                                            To share a spreadsheet file: Go to ... > Add People if you are on the listing page. Go to ... > Add People or  > + if you are on the spreadsheet editor. Enter the email address of the desired people you want to share the file with, set the access ...

                                                          Resources

                                                          Videos

                                                          Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                          eBooks

                                                          Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                          Webinars

                                                          Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                          CRM Tips

                                                          Make the most of Zoho CRM with these useful tips.



                                                            Zoho Show Resources