SEARCHeA2Similar to the first example. The SEARCH function is used to find a piece of data in an Excel spreadsheet. To search from the active cell from left to right row-wise select By Rows in the Search To check from top to bottom columnwise select By Columns.
Search function in excel is categorized under text or string functions but the output returned by this function is integer search function gives us the position of a substring in a given string when we give a parameter of the position to search from thus this formula takes three arguments one is the substring one is the string itself and one is the position to start the search.
The ISERROR function is used to check for error values. In the second formula ie. The SEARCH function is used to find a piece of data in an Excel spreadsheet. The Excel FIND function is a built-in Worksheet Function WS in Microsoft Excel which you can use to locate a sub-string or a specific characters position within a text string.