<\/p>\n
What does it do?<\/strong><\/em><\/p>\n Gets the position of a specific text within another text and allows wildcards * ?<\/p>\n Formula breakdown:<\/strong><\/em><\/p>\n =SEARCH(find_text<\/span>, within_text<\/span>, [start_num]<\/span>)<\/p>\n What it means:<\/strong><\/em><\/p>\n =SEARCH(text to be searched<\/span>, the source text<\/span>, [starting position of the source text]<\/span>)<\/p>\n If you want to check where a specific text is located in the source text, it is very easy to search for the position using the SEARCH Formula<\/strong>!<\/p>\n You might be wondering on what makes it different from the\u00a0FIND Formula<\/a>. The\u00a0SEARCH formula\u00a0<\/strong>is\u00a0case-insensitive\u00a0<\/strong>when searching for text, and it also allows for the use of wildcard characters like * and ?<\/strong><\/p>\n It is very cool when wildcard characters<\/strong> are used. The ? character<\/strong> represents any single character, while *<\/strong> represents any number of characters.<\/p>\n I explain how you can do this below:<\/p>\n
\n