You can use the word Like in a data validation rule.

Name: You can use the word Like in a data validation rule.
Brand: Quizplus
Rating: 4.9 (38 reviews)

Question

Quizplus · Accepted Answer

The word "Like" can be used in a data validation rule in Excel to specify a pattern or set of characters that must be present in the user's input. For example, a rule using "Like ??-####" would only accept input that has two letters followed by a hyphen and four numbers.

You Can Use the Word Like in a Data Validation