words

I have a table with several thousand foreign words (Hrvatski to be precise which is spoken in Croatia) which is mixed with a few English words. What I need to do is delete all the words in this table (words are in columns A-D) that are NOT found in the English Excel dictionary. In other words...

I apologize for not knowing the right words to use here (and if i knew the words i could look up the answer :-)) I have written a piece of VBA code that does what i need it to and have installed it in the spreadsheet that i was testing it on. So far so good. I now want to give the code to...

I want to ask you a question that I tried so much to look for. Can we searsh for a group of words at one time in excel?? For example, enter the Excel program a list about 10 words or a set of words and search for it at one time Or give it a set of words and it looks for it autothetically... my...

Hi Everyone, I want a formula that can count the number of time "HI" is in columnB but its with other words in some cells so It might just be "Hi" or "Hi, High, Tell, Sell," I tryied this but it finds other words with HI in them and counts them as well any ideas...

HI, I would like a formula that could find certain exact words ( 2 - 5 words) in a paragraph, and returns with values. Eg 3 exact words found in a paragraph, return values = 3 thanks....

Hey guys I have been looking for this for at least 3-4 hours and I give up. How can I format a column to highlight all duplicate number values, ignoring empty cells or cells with words, without using scripts? I want to use Google Docs with this and if I am not mistaken I can't use scripts. This...

----------------------------------------------------------------------------------------------------------------------------------------------------------- Example String: "calculating cumulative stats for quarters"...

Ok guys, I am going to try and explain this clearly this time. I have a spread sheet, in column A there is a list of words. There is a button on the spread sheet, we will call the button tst. The layout for column A is a word, then some cells containing info then another word. The words that are...

Good day I need take last words from cells. as example in cell A2 I have text "word1 / word2 word3/ word4 /word5/word6 word7" In cell B2 I need get "word6 word7" I can do it by VBA, but now I need to get it by formula. How I can get it ? Thanks at advance

I have the first 8 columns in my sheet (A-H) set to desired widths. Does anyone know of any easy way to assign subsequent blocks of 8 (I-P), then Q-X), etc. to widths matching the first 8? In other words, A, I, & Q... would all be 17.57. B, J, R would all be 9.43... Many thanks in...

Hi, I have lots of words that need removing from a column, the best way I can think is to use a hidden reference sheet that contains these words that I want to remove from another document, is it possible to look for each word in the hidden sheet and if found in the other document store it in...

OK have a print macro that works well and combined it with Post #12 from https://www.mrexcel.com/forum/excel-questions/39788-old-excel-macro-language-2.html with a slight modification. This is it from my spreadsheet Application.Wait (Now + TimeValue("0:00:20")) Application.Goto...

I have a list of key words in column A in Range A2:A11. In column B (Range B2:B2334) I have text (1 paragraph in each cell). For each cell in column B, I want to check if any of the words in column A are included. Thank you for your help. Manish

I need help with vlookup, I want to be able to type the first letters of a word in and have all matching words come up in the dropdown list, any help would be appreciated thanks.

In column A I have a list of 500 words. In column B I have a list of 300 words. In column C I want to list all the words that column A and B have in common. As seen in the example below. <tbody> elephant crocodile elephant rat mosquito circus elephant </tbody> Thanks for your help!

Hi! My problem is the following. In cell L2 is a sentence that can contain 4 different words. The function first need to find the word, then act on it. As exampel: text WW text text text text text XX text text YY text text text text text text ZZ When cell l2 contains WW, cell M2...

Hello, I am not nearly skilled for all this stuff. So here is the issue. I have my excel tracking sheet with all sorts of names, info, dates, etc. I want to be able to move whole rows up and down depending on the word I change in the first column. That first column when clicked on has a drop...

I have words in a cell separated by a semicolon and need a macro to replace the ";" and put the words in a alpha list within the cell have this: black;blue;green;red;purple want this: black blue green purple red

Hi guys, Is there any way to search a cell for text words that the words do not have to be in order? I can get this formula to work using if everything i type is in the exact order, but not if i try to switch some words around. Formula using search: =isnumber(search(trim(C1),A1)) See...

Hi All, Forgive me for the following text explanation but we are blocked from uploading items at work and I’m at work at present. I have a basic table for recording health and safety, currently spanning A1 to N46. Column C contains words that relate to the type of health and safety issue...