contain text

  1. J

    excel vba clear cell value with if contain specific cell value

    Good evening everyone, I'm looking for some code in vba that can find specified dates in a line, if the date is not the same I need to delete the 3 columns, I want to leave only dates in the line that correspond to date1 and date 2 as in the example before later
  2. B

    Contains condition with multiple IF/OR

    Hi Can someone help me with below with formula or VBA code. I have string in column T and I need below to be done in column AK. If string in column T contains 07X OR 18X then publish Yes in "AK". If column "T" has 08X OR 04X OR 07A the publish NO in "AK". else publish as Others. Thank you in...
  3. O

    Return cells only containing certain letters

    Here’s my scenario: I have a list of words and a list of letters. I want to return the words that contain letters from the list of letters and ONLY from the list of letters. For example: WORDS: cog, bib, ab, back, cab LETTERS: A, B, C WORDS returned: ab, cab Thoughts?
  4. M

    HELP with IS BLANK statements

    Hello, I am trying to create a formula that will do; If C2 AND D2 AND E2 contain text (date format) then "READY" else "BLANK" in another cell. If any of the three cells have a date it still needs to show blank, only when all three have a date can it show ready. I have tried various If...

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