The LIKE function tests whether a mask can be found in text and returns TRUE or FALSE accordingly.
text is any text or cell reference.
mask is a pattern to search for. Wild cards * (a string of any length) and ? (a single character) can be used in the mask.
The LIKE function is case sensitive.
Examples:
LIKE("This is a text string", "This") returns FALSE
LIKE("This is a text string", "This*") returns TRUE
LIKE("This is a text string", "?his is a*") returns TRUE
See also:
FINDTEXT(find_text, within_text, start_num)