Скачать или смотреть Excel String Function - Search and Find

The SEARCH function returns the position (as a number) of one text string inside another. If there is more than one occurrence of the search string, SEARCH returns the position of the first occurrence. SEARCH is not case-sensitive but does support wildcards. Use the FIND function to perform a case-sensitive find. When SEARCH doesn't not find anything, it returns a #VALUE error. Also note that when find text is empty, SEARCH will return 1. This can cause a false positive when find text comes from a cell, and the cell is empty. The FIND function returns the position (as a number) of one text string inside another. If there is more than one occurrence of the search string, FIND returns the position of the first occurrence. FIND does not support wildcards, and is always case-sensitive In this video, you will learn about Excel String Function - Search and Find.