{"id":1306,"date":"2018-07-04T10:19:08","date_gmt":"2018-07-04T10:19:08","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1306"},"modified":"2023-11-03T13:29:33","modified_gmt":"2023-11-03T13:29:33","slug":"search","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/search\/","title":{"rendered":"SEARCH function"},"content":{"rendered":"\n
The Excel SEARCH function is used to find a specific text string within another text string and return its starting position. It’s a helpful tool for locating a word or phrase within a cell’s content.<\/p>\n\n\n\n
=SEARCH([text_to_find], [within_text], [start_num])<\/strong><\/p>\n\n\n\n The SEARCH function is straightforward to use. Let’s look at some examples:<\/p>\n\n\n\n This formula will return 11 because it finds “apple” starting at the 11th position in the text.<\/p>\n\n\n\n Here, it returns 24 as “banana” starts at the 24th position in the text.<\/p>\n\n\n\n By specifying a ‘start_num’ of 12, it returns 19 because it starts the search after the first “apple”.<\/p>\n\n\n\n You can use the SEARCH function to perform various tasks, such as extracting data based on specific keywords or finding patterns within your data.<\/p>\n\n\n\n Keep in mind that SEARCH is not case-sensitive. If you need a case-sensitive search, you should use the FIND function.<\/p>\n","protected":false},"excerpt":{"rendered":" The Excel SEARCH function is used to find a specific text string within another text string and return its starting position. It’s a…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
text_to_find<\/strong><\/td> The text you want to find within the ‘within_text’.<\/td><\/tr> within_text<\/strong><\/td> The text in which you want to search for ‘text_to_find’.<\/td><\/tr> [start_num]<\/strong><\/td> (Optional) The position within ‘within_text’ where the search should start. If omitted, the search starts at the beginning. If specified, the function starts searching from that position.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to Use<\/h2>\n\n\n\n
=SEARCH(\"apple\", \"I have an apple and a banana\")<\/code><\/pre>\n\n\n\n
=SEARCH(\"banana\", \"I have an apple and a banana\")<\/code><\/pre>\n\n\n\n
=SEARCH(\"apple\", \"I have an apple and a banana\", 12)<\/code><\/pre>\n\n\n\n