cpt

  1. D

    Reverse Comma Delimited

    I receive a healthcare financial report. Each account has several services called "CPT." Each CPT has an assigned payment code called "EOB Code." The report I get lists all EOB codes for the account next to each CPT. I would like to break this down to only list the EOB code applicable to each...
  2. D

    Text to Columns in Access Query...

    Hello everyone. This may not be possible, but here goes.. In an Access table I have an account number in one column and an assigned CPT Code adjacent. One account number can have multiple CPT Codes (all different). I need to find a way to have only one account number (no duplicates) in the first...
  3. T

    VBA - Problem with short code

    I have the code like below, the problem is that the state after and doesn't work. Seems to be that works only fisrt part of IF.Do you have any sugestion? I want to count workbooks without sheet named "BOM" and cell A13 different of END. Dim ww As Integer Dim cpt As Integer Dim Wb As...
  4. K

    return 5 characters before a specific word

    Hi there, How do I extract just 3 characters before a specific word "loadsheet" within a cell <tbody> description output <tbody> blah blah auh cpt loadsheet blah blah </tbody> cpt </tbody> Regards, Bernard

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