cell contains

  1. T

    VBA Replace cell value with cell contains

    Hi, I'm looking to use the replace to change a known value to another value. but i have multiple values to i want to list them all out in a sheet and loop once i've replaced the values in the list i want to loop and do the same in another work book for example my list is Change from...
  2. D

    If Cell B = text in col C, input value from col A

    Hello everyone, I wanted to know if there was a formula or macro that I could use which would look up a string of text in column B:B and if found in column D:D return the value which correlates to its row, but the value i want is in column A. Its hard to explain but i am attaching an image...
  3. N

    VBA to find certain text and then delete whole rows containing it in all sheets of a workbook

    Hi, I haven't written/recorded a macro in a very very long time and am struggling to try and do something simple. I need to search all worksheets of a file (containing around 100 tabs) for cells which contain the text "_web.pdf". There is also other text in the cells. Then for all cells which...
  4. J

    How to count if cell contains text from a range

    Hi, I have this formula: =COUNTIFS('RAW DATA'!$H:$H,"="&$A$1, 'RAW DATA'!$E:$E, $A7, 'RAW DATA'!$G:$G, "*U6:U28*") In the last criteria I am trying to count if the cell contains text from a range but the result it is giving me is 0, when I know the output should be 12. And I need it to be a...
  5. J

    Locating a cell in a row with a specific name

    Team, I am trying to use an excel spread sheet copied into a Sheet in excel to input information. Example: Sheet 1 Cell A2(in cell A2 =desired number) I want information to be filled with units sold by Location1. The location information will be in Sheet 3. The difficult thing is the...
  6. B

    IF D2 contains X then divide I2 by 10

    Hi All, Have a major problem with our monthly call billing, we basically have a spreadsheet which shows a number called and the total cost of the call. However our the calls for 0844 & 0845 numbers are 10x the actual cost! Does anyone know how i can run a macro which will find the 0844 &...
  7. K

    VBA - If Cell Contains Email address

    Hi There, I want to get a VBA code for checking if a particular cells has got any email address Suppose Cell A1 = abc then it should give error "Please enter a valid email address" and If Cell A1 = abc@xyz then it should let the user enter that value as it is a valid email address VBA code...
  8. H

    cell contains other cell's text - not a specific text

    Hi all!;) I will appreciate your help. I need to find out if a certain cell contains other cell's text- it's not a specific text.If A1 contains the text in C1.... do you have any idea how to do that?? Another issue if you can figure out is the formulas I've tried so far couldn't identify if...
  9. S

    Formula Question: Return a Value if a Cell Contains a Letter within a Text String

    Hi, I have a cells drawing information from a table. In this table I have model numbers to depict products in one column. In another column I have sales totals for those model numbers. I would like to sum the sales for those model numbers if the model number contains an S. Conveniently...
  10. F

    sum of item. containting different words

    <TABLE style="WIDTH: 159pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=211><COLGROUP><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><TBODY><TR...

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