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
Watch video Excel function SEARCH and FIND (Differences) online without registration, duration hours minute second in high quality. This video was added by user Университет Алексея Полянского 19 December 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 710 once and liked it 9 people.