identify code

  1. O

    recognise format of code in Power Query to extract

    >10k of rows of short sentences have within then, usually, a code. I need to extract this code, but how do I get PQ to recognise its format, which is: 230F-115-04 301F-115-05 30A-115-26 30F-1180-02 30F-118-03 30F-1252-04 130H-1252-05 30F-1252-18 30F-126-01 40G-127-01...
    • ooptennoort
    • Thread
    • extract format identify code power query recognise text
    • Replies: 18
    • Forum: Power Tools
  2. G

    VBA Code to create a 'missing parts' list

    Good day to all, I am in need of a VBA code that can identify the missing part numbers from a list (via vlookup function I guess) and list all those part numbers in a textbox so the user can choose to upload the parts in the database or ignore Thank you in advance for your help!
  3. C

    PATTERNCOLORINDEX identification sub?

    I'm using this code and need to change the color. Is there a short chunk of vba code (Sub) I can use to identify other cells individually to find out the code equivalent? I've found cross refc charts such as these Color Palette and the 56 Excel ColorIndex Colors that show RGB color numbers...

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