wild cards

  1. S

    How to find a Match Using a Wild Card

    Hello, I have the following formula: =IFERROR(INDEX(Analysis!$B$1:$B$278, SMALL(IF(Analysis!$A$1:$A$278=$C$44, ROW(Analysis!B1:B278),""), ROW()-44)),"") In cell C44 I have text that I want to find. X*XXXXXXXXXXXXX I want to find the match for this but I need to make the second letter in...
    • Sturgeon
    • Thread
    • formula formula array if function formula wild cards
    • Replies: 5
    • Forum: Excel Questions
  2. D

    B* vs BH with countif statement

    Hi Everyone, I am using countif and ran across this issue: I want to count how many "B*" and also "BH" but am getting the * used as a wild card and only want to count it as a character. All suggestions welcome. Thanks, Dennis
  3. J

    Trouble with Wild Cards

    Hello all - Here's where I am stuck: When the word 'NEW" appears at any place in a row, I want to retrieve the part number located a single space away, i.e., USE 467.209 returns 467.209. And there are instances where additional text follows the number (USE 55-1235OE,2 LEAF AIR BEAM L/H...
  4. L

    Explanation of Excel Vocab and Symbols / Wild Cards - $ ~ ' etc

    Does someone have a good resource on learning Excel Vocabulary, symbols, wild cards, etc? I have learned many of them in passing, but I would like to have a reference of everything Excel uses as far as arbitrary characters and words (e.g. Concatenate, really? is that a real word?)
    • Legacy 277976
    • Thread
    • dollar sign symbols tilde vocabulary wild cards
    • Replies: 1
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top