Excel function SEARCH and FIND (Differences)
Excel function SEARCH, and FIND, determine the number of characters before a specific character. The find function understands wildcard symbols, the function to FIND the register understands
Record on consultation: https://vk.com/id8547020
For example, consider how the function of the FIND
in the cell A2 contains the text "the Sun shines in the Winter is worse than summer"
=FIND("s" (the search criteria);A2(the cell in which you want to determine the number of positions);0(what position will report) so the result would be 14 because the distance to the first lowercase letter "C" 14 characters. The search feature in this case, gave a result of 7 as found in the first letter "C" and took the register.
The SEARCH feature is able to understand special characters such as
in the cell A2 contains the text with numbers of different length (1 12) (124 233) and our task in this case is to find the distance to slipped, so writing a function like so.
=SEARCH(" "&"*";A2;0) we will get different results is equal to 1 and 3 in this example.
#excel #Excel #Polanski
Смотрите видео Excel function SEARCH and FIND (Differences) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Университет Алексея Полянского 19 Декабрь 2016, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 71 раз и оно понравилось людям.