words

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...

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...

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...

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...

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

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")

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...

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...

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...

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

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

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

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...

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...

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...

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...

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...

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...

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...

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"