excel wildcards

Question

I was wondering for wildcard if is in the front, back, or middle if I could filter by single and/or many characters.
Like in SQL a single wildcard would be a [], many is %, _ another single character, etc.... if you get my point

Answer 1

Hi @Jonathan Brotto

> I was wondering for wildcard if is in the front, back, or middle if I could filter by single and/or many characters.

Could you please share us with a smiple sample that show us some data and how you filter these data?
The location of wildcard in Excel formula is determined by the different character/ characters position in the two sets of comparison data.
For example, in your another thread, "two price lists with slight variation on part #", the wildcard needs to be added at the front, like "?"&D2 or "#*"&D2.

> Like in SQL a single wildcard would be a [], many is %, _ another single character, etc.... if you get my point

In Excel formula, a single wildcard would be a "?", many is asterisk.
For more, please refer to "Using wildcard characters in searches" and "Wildcard" (Please Note: Since the web site is not hosted by Microsoft, the link may changed without notice. Microsoft does not guarantee the accuracy of this information).

Any updates, welcome to post back.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---