Special characters used to represent one or more unknown characters in search, filter, and function criteria.
Попробовать с ИИWildcards include the asterisk (*) to represent any number of characters, the question mark (?) to represent a single character, and the tilde (~) to escape these special characters. They are essential for performing partial matches in functions like VLOOKUP, SUMIF, and the Find/Replace tool.
=COUNTIF(A1:A10, "*data*")Using 'S*t' in a search will find 'Sat', 'Suit', and 'Sheet', while 'S?t' will only find 'Sat' or 'Sit'.
Place a tilde (~) before the asterisk, like this: ~*.