words

  1. T

    =IF Help

    Hi, Can someone tell me why my If statement is not working...
  2. S

    Text formulas returning 0

    Suddenly all of these formulas (like below) are no longer just returning words, they are returning 0's. All of the other cells referenced have words in them. =IF(Developer!J46="Network","C: Drive Daily Archive", Developer!E42 & " Daily Archive")
  3. R

    IF / AND with exceptions

    Hi All - Looking for help with a problem. I have an IF function with an AND inside it, the AND has multiple rules. Currently, the formula works great but I am looking for one of the AND rules to allow for an exception based on words in a separate cell. Current Formula...
  4. N

    I'm Struggling to loop this VBA code

    Hi, I have searched for days to find this code as I am not knowledgeable enough to write it myself. I want to expand this VBA code from a single use code to a multiple use code. eg looping through the range to the final row. This code works exactly what I want it to do, but only for one row, I...
  5. D

    Conditional formatting with or function, not case sensitive...

    Is there a formula I can use to search cells in a column for say 3 specific words whether they be on their own or in a text string. I'd like to search for up to 10 words but perhaps this is not possible?! I have used isnumber(find, but can not get it to work with the or function, I have used...
  6. L

    Out Date "OUT" or Return Date "Return"

    I want that if Out Date column has a date, on the Status Column it will have the words OUT but when there's a date is Return Column it should say Return in the Status Column
  7. T

    Macro to spell check just the words in a texbox?

    Hi Everyone, I need a macro that when it runs will check the text in a standard shape textbox called "Words 1" please help if you know how to do this, thanks Tony
  8. E

    Return Only Different Words In Sentence

    i have two columns and each column has a text sentence. I just need to create a third column that shows only the words that do not exist in both cells. Example; <tbody> If John wants to if john does john if he can might if he can wants to does he can might </tbody> kind thanks, Eddie
  9. kelly mort

    Finding words match in a string or an array

    I don't want to break any rules here. And if I am doing so then I am sorry. I have posted a quest here https://www.mrexcel.com/forum/excel-questions/1109916-vba-code-compare-contents-two-textboxes.html Which looks like what I am posting again. But this seems a bit clearer. After re-looking at...
  10. S

    Comparing text in 2 different cells

    Hi It is easy to do the above as per https://exceljet.net/formula/compare-two-strings. My question: Can one do such a comparison without extra spaces in one cell being counted in the comparison? In other words, if the only difference between the 2 cells is an extra space in a sentence, I...
  11. F

    VBA: Find and replace words in column

    I've tried to craft some VBA to find and replace an array of words but this macro replaces words not in order. I started with code found here. https://www.thespreadsheetguru.com/the-code-vault/2014/4/14/find-and-replace-all Basically I'm adding an "S" to the end of certain works to make them...
  12. C

    Splitting a Text String into Identifiable Words and Comparing them to other Cells

    Hi! Newbie here, so please be gentle... I have two columns of data where all the cells are text strings. I want to be able to compare each cell in the Column 2 with all of the cells in Column 1 to find which cell from column 1 has the most words that match the cell in column 2. None of them...
  13. aaaaa34

    VBA to delete row itself, 5 upper rows and all below if it includes specific words

    Good afternoon all, I want to have VBA code to delete row itself, 5 upper rows, and its all below rows if it includes these words: "Alternative Matches" Please have a check the attached file in this link and you will see example sheet and desired result sheet after VBA runs...
  14. V

    Report most common text occurrences in strings of text within a table

    Hi, I have 1400+ survey responses and wish to produce a report of the most common key words in strings of text within a table of responses. An example of a response would be: The ceremony ran very smoothly and did not go on for too long Nice short ceremony Decorated the venue brilliantly The...
  15. I

    Searching Text Strings for Most Occurring Words

    Hello, I am wondering if anyone knows a formula to search for commonly used words in an excel column. I have data where one column is written text filled in by someone and I would like to search all of the columns for the most commonly used words. For example, several cells in column A contain...
  16. Y

    Search words in Text file

    Assuming I want to search "He resides at Alaska" How can i find this in a text file even when it is scattered all over in the file. So that if each of these words are found in the text file, it should give me a message box "Yes"
  17. U

    Deleting query

    I want to delete NA from my spreadsheet without getting it deleted from middle of the words like original using vba. Please help
  18. M

    Check first & last letter from 2 columns against a column of words

    Hello, I'd like to check if a word contains matching first/last letters from 2 cells. I can't quite get it to work. In fact, it doesn't work at all - I over sold 'quite'. Eventually I will check MANY words for MANY different first/last matches so I want to automate obviously. Example data...
  19. berty2000

    Delete Only Colums containing These words

    Hi guys Im trying to delete a couple of columns that contain certain words but cant seem to get it to work. This is what i got so far Set MR = Range("R10:DA80") For Each cell In MR If cell.Value = "Total Prod Changes" or "All Prod" Then cell.EntireColumn.Delete Next
  20. J

    Search for exact string and return lookup value

    Hello, This has been racking my brain and my original formulas are pulling in the wrong values. Here is what I'd like to do... I have two Excel Tables; Table 1 where all my data exists. I would like to have a formula to determine if CATEGORY = A then I want to check if any LOOKUP words (...

Some videos you may like

This Week's Hot Topics

Top