contains word

  1. E

    Need help: nested if where it's based on criteria in one column then return values from another column

    I have 2 spreadsheets. One is the Master, the other is called Export. I need to get the numbers from the export into the master (column C) each month based on the item row name and the IDs in column A need to match. I kept trying: IF column B CONTAINS this, then pull in column T from other...
  2. E

    Conditionally Format for cells that do not contain....

    I'm looking to Conditionally Format a cell using a formula for another cell if it does not contain certain letters. Example: I need to conditionally format Cell B1 to be a certain color if Cell A1 does not contain "T","TC","M","MC","B", or "BC". So when I type in anything other than those...
  3. M

    Find the cells that contain certain words of another sheet

    Hi, I have an excel document that contains 2 sheets. I want to look in the first sheet, in column A if the cells contain words from the list in column A of the second sheet. I do not want to find exact cells, but know which cells contain one or more words (in column A of sheet 2) in the texts...
  4. A

    If cells contain Word

    I want excel to look at a cell and if it contains the word "special" then I want it do run my code. I am not sure how to do this. Here is what I have so far. Sub special() Count = Range("a65536").End(xlUp).Row For i = 2 To Count If cells(i,4).value = [contains the word "special"] then...

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