Wildcard Functions

The following is a list of functions that accept the wildcard characters (? and *).

Function	Description
DIR	Returns the name of a file or directory matching a pattern or attribute.
KILL	Deletes an existing file.
LIKE	The pattern matching operator.

These functions do not support wildcards.

INSTR	Returns the position of a substring within a larger string.
INSTRREV	Returns the position of a substring within a larger string, starting at the end.
REPLACE	Returns the text string with a number of characters replaced.

For a list of the Excel Functions that can use wildcard characters, please refer to this Wildcard Functions page.