Document editing comes as a part of many occupations and jobs, which is why instruments for it must be available and unambiguous in their use. An advanced online editor can spare you a lot of headaches and save a considerable amount of time if you have to Put formula record.
DocHub is a great example of an instrument you can master in no time with all the important features accessible. You can start modifying immediately after creating an account. The user-friendly interface of the editor will enable you to discover and use any function right away. Feel the difference with the DocHub editor as soon as you open it to Put formula record.
Being an integral part of workflows, document editing must remain easy. Using DocHub, you can quickly find your way around the editor making the required changes to your document without a minute wasted.
to filter all those records that contain the word apple from this data set in the formula bar equal filter function open parenthesis select the cells containing data comma is number function search function now the word to search for double quotes apple double quotes comma select the cells containing text data close parenthesis again close parenthesis once again close parenthesis enter and we have all those records that contain the word apple for the records that contain the word mango replace apple with mango