> 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
> 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.