If you want to apply a minor tweak to the document, it should not require much time to Generate formula record. Such a basic activity does not have to demand extra training or running through guides to understand it. Using the appropriate document editing resource, you will not spend more time than is needed for such a swift edit. Use DocHub to simplify your editing process whether you are a skilled user or if it’s the first time making use of a web-based editor service. This instrument will require minutes to learn how to Generate formula record. The only thing needed to get more productive with editing is actually a DocHub account.
A plain document editor like DocHub can help you optimize the amount of time you need to spend on document editing regardless of your prior knowledge of such instruments. Create an account now and enhance your efficiency immediately with DocHub!
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