1. O

    cut off words (or replace by "") in list from strings

    Power Query: I have a column with strings and a list of words I need found in that column AND (this is the difficult part) when found these words need to get cut off from the string (or replaced by "")? How? A sort of textual substraction... have been trying so long... list.accumulate etc...
  2. I

    Nested For Each Statement: Identifying Key words from Range within a Range

    Dear Mr Excel I would be so grateful for some help with this. I have 4 Sheets that contain data that i am trying to write a code for. MessagesSheet (Which is named "replies" followed by "date" and "time"): This contains text messages received. The data is organised as follows: Each row...
  3. C

    Count Words in cell and ignore blanks

    Hello, I am trying to create a word/phrase counter where it counts the contents of the cell (regardless of how many words are in there), and shows how many times it appears in the range. I apologize if it sounds confusing, but here is the example: Source: Genre Number Historical...
  4. N

    Top15 words on worksheet 1

    Hi all, Recently I found this post on MrExcel Using Thesaurus with VBA Great tool, which I use to collect first associations with images. Since a synonym would also have done the job I decided to add up to 10 of them using the code mentioned above. Currently I use it on worksheet 1 (only the...
  5. T

    =IF Help

    Hi, Can someone tell me why my If statement is not working...
  6. 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")
  7. 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...
  8. 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...
  9. 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...
  10. 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
  11. 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
  12. 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
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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"

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