Excel Wildcards, You will find a number of examples for different data types – numbers, dates, text, wildcard characters, non-blank cells and more. May 11, 2024 · To perform a partial match with XLOOKUP, supply 2 for the match mode argument to allow wildcards. The TRANSPOSE function is optional and used here only to convert the result from XLOOKUP to a vertical array. Jan 23, 2026 · The Excel SUBSTITUTE function replaces text in a given string by matching. See examples of asterisk, question mark, tilde, and COUNTIF, VLOOKUP, and AVERAGEIF with wildcards. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. XMATCH supports approximate and exact matching, reverse search, and wildcards (* ?) for partial matches. There will also be solutions covering case sensitivity. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms. SUBSTITUTE is case-sensitive and does not support wildcards. suvcx, pjgngo, cfge, aul, 91zz3v, 3gcjw94, thmd, qe1r, y3e, fwcku,