question

JonathanBrotto-3536 avatar image
0 Votes"
JonathanBrotto-3536 asked emilyhua-msft commented

excel wildcards

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

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered emilyhua-msft commented

Hi @JonathanBrotto-3536

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.





· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Ok now I am getting the nature of wildcard in excel. Now for a situation where for example a part # with 2 sections where on one list the middle would be broken by a "-" in one list and another with a space " " using something like mid and find formula to break it apart and to find a common string with different divider character using a "?" for a single character.

1 Vote 1 ·
emilyhua-msft avatar image emilyhua-msft JonathanBrotto-3536 ·

@JonathanBrotto-3536

Thanks for your reply.

Yse, if there is a space "", or a "-" breaks the text data, you can use Left function, Right function, Mid function and other functions to split the text data first, and then add the wildcards, combine them.

1 Vote 1 ·