words

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

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

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

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

The following codes only manage to filter for 2 words. (i.e. txt, txt) When user inputs more than 2 words to filter (i.e. txt, txt, txt), an error just returns. Is there any workaround to filter more than 2 words, for a particular column? Thanks! Sub Test() iTxt = InputBox("containing ...

I have a worksheet full of data, across which I'd like to see what words are used most often in it? Then to see all results, from most frequently used, to least frequently used words? *I'd like to be able to do this both across a worksheet, as well as along a column, or row? I know the...

I have a worksheet full of data, across which I'd like to gauge what words + 3 words on either side appear most frequently in that set of data. To begin, I'd like to see what words appear most commonly in this data. And then to search for some of those words + 3 words on either side them. So...

Hi, I have a userform with multiple comboboxes on, but i'm having trouble with one in particular. When clicking the drop down, it lists the two items from the named range. But when i select an item, the userform will then show either 0 or 1 (rather than the words "Single" or "Multiple" from...

I have the following code that basically searches column O and deletes any rows that contain the words in the array. Only problem is it wont remove rows where the words have capitals in or vice versa. I have lots of keywords to search for so adding different versions of each word isn't an...

I need a countifs column that will count values in columns that contain the words TA2 and EFG. The column headings are something like "2019: Year 11 TA2 (22 Jan 2019): Mathematics: EFG" So I need to count any value where the column that contains the words TA2 and EFG and the student has a...

Hi I facing an issue in extract words between some specific word for example: I am studying in <start:loc> London <end> but I live with my mother in <start:loc> Manchester <end> and in vacation I go to <start:loc> Cardiff <end> I want to extract the word between tags <start:loc> <end> in one...

Hi Team Can anyone help me please? I have a long string in column A. What I am trying to do is check for a list of words (need wildcards) (the word or words will only appear (if at all) once) and if the word(s) exists, copy that word to a separate column, say B. So check for say, "book"...

Looking to return an answer when text in a different cell contains the same text. I as using the below formula, but it does not seem to be working. =IF(ISNUMBER(FIND(A62,Licenses)),"YES","NO") NOTE,the actual text in A62 may not exactly equal "Licenses", but instead may contain that text...

Dear all, I need to combine 300 words in a column (separate cells) in to 30 words in single cell each. I will have to do it many more times.... I use the forumula =concatenate(transpose(INDEX(A1:A1000,30*(row()-1)+1):INDEX(A1:A1000,30*(row()-1)+30))&" ") and drag it down. Problem is I have to...

Hello, I am trying to create an excel function that will identify two specific words embedded in messages of varying lengths (that I scraped from a message board online) and delete all the text in between those two words. Specifically, the message board that I scraped the data from allowed...

I am using the following UDF to split a long string into rows of predefined number of words in based on input incell "D3". Public Function SplitOnNth(ByVal inputStr$, ByVal StartPos&, ByVal NumWords&) As String Dim arr() As String, i As Long, newArr() As String arr =...

hello, i want to convert the rupees from numric to words. how can we do that?

Hi everyone, I've been trying the whole day but can't figure it out. I need to align words in two rows. (It's used in an automatic header.) What I've stumbled upon was that adding spaces doesn't automaticly mean words align perfectly. What is want to accomplish is something like this. <tbody>...

Hello, I tried to find an example online, but no luck. I have a huge list of strings that some of them end with "ini" as a suffix. I would like to replace it with "not". The trick here is that the length of words is variable, it can go from 3 until 15 and more. Not all words have such suffix...

How to shorten the length of the words in excel, Foreg. if i have words of 50 characters and i want to shrink it to 25 , is there any formula to do so?