Document editing comes as an element of numerous occupations and careers, which is the reason tools for it should be reachable and unambiguous in their use. A sophisticated online editor can spare you plenty of headaches and save a considerable amount of time if you need to Construct formula record.
DocHub is a great demonstration of a tool you can master right away with all the valuable functions accessible. Start modifying instantly after creating your account. The user-friendly interface of the editor will allow you to locate and employ any function in no time. Notice the difference with the DocHub editor the moment you open it to Construct formula record.
Being an important part of workflows, document editing should stay simple. Utilizing DocHub, you can quickly find your way around the editor and make the necessary alterations to your document without a minute lost.
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