SEARCH function is used to find “position of character or text” in an available cell.
Search function is NOT case sensitive, means it will search “r” for text contains “r” and “R”. If you want to find value with case sensitive, then try FIND Function
=SEARCH(find_text,within_text,[start_num])
find_text argument, is the used to give character/ text or cell reference for which position is required to find
within_text argument, is used to give the cell reference from which find_value to be searched
[start_num] is optional argument and is used to specify the character from which search should be started. By default, the first character is 1, however if you want search should be started from 2nd find_text value then it should be position of 2nd find_text value and so on..
Here we have some examples, where:
– “Column A has various strings,
– “Column B” shows the sample formula that is applied,
– “Column C” shows the output of the function and
– Explanation is provided in Column “D”
– Search function will also work with Wild characters i.e. asterisk (*), question mark (?). Asterisk will find any series of characters and Question mark will find a single character.
– If you want to search actual * or ? (Asterisk or Question Mark) then type tilde (~) before * or ?
– Function should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”.
– If function parameters are not correctly applied in the function, then it will give output as “#VALUE!”
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us
Watch: How to use WORKDAY & WORKDAY.INTL Function in Excel? What is WORKDAY Function? The WORKDAY function in Excel calculates a date that is a specified number of working days before or after a given date. It…
Watch: How to use TODAY & NOW Function in Excel? What is TODAY Function? The TODAY function in Excel returns the current date in a serial number format. Click here to Read full Tutorial What is…
CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.
RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank
The Article of DATEVALUE explains how to use Excel functions to change text into dates and numbers into dates. It also shows how to convert text strings into dates without using formulas. You’ll also learn…