Microsoft Excel – Text Functions – SEARCH and SEARCHB formulas
Another set of Text functions SEARCH and SEARCHB in Microsoft Excel are useful to find the text within the given text. These functions returns the index value where it finds the text in the given text. These functions are non case-sensitive. That means, these considers the text “APPLE” and “apple” as same. SEARCH formula This […]