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
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.
Delta Symbol in Excel The Greek Capital Alphabet letter Delta (▲) and is commonly discussed topic in Excel. This is being used for various purposes i.e. changes in quantity, insert the symbol in excel etc….
If you want to print your Excel spreadsheets with gridlines, this guide is for you. Adding gridlines makes your data easier to read and gives your spreadsheet a clean, organized look. In this post, we’ll…
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
Add new line in Excel cell lets you type on multiple lines within the same cell. Instead of having all the text in one long line, you can split it up to make it easier…
Microsoft Excel helps you organize and work with data in many ways. When you have a lot of information or need to break it into parts, splitting cells is very useful. Splitting cells means taking the content of one cell and dividing it into multiple cells. This can be especially helpful for separating names, addresses, or other data that are combined in one cell. Learn how to split cells in Excel using its built-in functions and formulas.