exception formulas

  1. J

    Substitute All Except

    Hi, everyone, Is there any way to substitute a character or series of characters from a cell with other characters, but with some exceptions? For example, substitute (or replace) all instances of "X" in cell B1 by cell A1, except "XP", "Xbox", "Xochitl", "Xmas", and a few others. I had written...
  2. sllafleur

    I need an exception formula

    This is what I am trying to do. I have 4 core sheets that I input information into and it automatically calculates in the "monthly" and "quarterly" sheets. Right now, I place a tally mark in everyday the volunteer firefighter went to a call. Somedays they have one and some days they have five. I...
  3. S

    Formula using "except"

    Ok I have a confidential spreadsheet which is covered in formula so let me explain my problem In A1 I have current jobs In B1 I have employee on that task In C1 I have work stage E.G. Active, Complete ETC In D1 I have target completion date The formula I am using is...
  4. E

    Finding Formulas in Workbooks

    Hi, I need to search over 400 Excel workbooks in over 90 sub-folders for the existence of formulas entered in cells. These specific workbooks are not supposed to have any formulas in them so I’m trying to easily find any exceptions. <o:p> </o:p> How can I do this and either pipe the output...

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
Top