What would you use to locate a text in spreadsheet and how does it work?

I am going to assume you are using a recent version of Excel or something like it. Finding and/or replacing text in Excel is easy. Click on 'Edit' and then 'Find' (shortcut is Ctrl-F). You then hav a few options on whether you want a case sensitive search, scope of the search (in case you have multiple sheets for example). Usually you can accept the defaults - just type in the text you want to find and hit OK. Note - if you have a range selected (highlighted) in Excel when you do a search it will only search in that range - if you want to search the entire sheet make sure to deselect any ranges. If you want to find text across a number of spreadsheets you can use the Windows search option - let's says you want to find 'XYZZY' don't know which spreadsheet it is in - do Search from the Start button (use classic preferences). - put '*.xls' as 'All or part of the file name' and 'XYZZY' as 'A Word or phrase in the file'.