DocHub makes it quick and straightforward to tack recipient in xls. No need to instal any software – simply upload your xls to your account, use the simple drag-and-drop user interface, and quickly make edits. You can even work on your PC or mobile device to modify your document online from any place. That's not all; DocHub is more than just an editor. It's an all-in-one document management platform with form constructing, eSignature features, and the option to enable others complete and sign documents.
Each file you edit you can find in your Documents folder. Create folders and organize records for easier search and retrieval. Additionally, DocHub ensures the protection of all its users' information by complying with stringent protection standards.
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