Using wildcard characters in searches - Microsoft Support
WEBUse wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
FIND, FINDB functions - Microsoft Support
WEBIf you don't want to do a case sensitive search or use wildcard characters, you can use SEARCH and SEARCHB. If find_text is "" (empty text), FIND matches the first character in the search string (that is, the character numbered start_num or 1). Find_text cannot contain any wildcard characters.
BYROW function - Microsoft Support
WEBBYROW function. Applies a LAMBDA to each row and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows.