words

Hi Folks, I am attempting to use VBA to modify address data because the first two address columns have character limits and my data tends to exceed the limits. I wish to modify text strings within cells i.e., to find and replace words within text strings with abbreviations. For the below code...

Hi friends, I am not sure how to answer this question for a VBA class i'm taking. How would I count only words with 5+ letters? Thank you! CatLadee :confused: msg = "Total words: " & UBound(arrWords) - LBound(arrWords) + 1 & vbNewLine & "Large words:" & ????? MsgBox msg

I need to get up to speed with formulas, but I'm battling to meet a deadline to draw out key info on a 30,000 row spreadheet. Basically I currently have a formula in U2 as follows: =IF(E2="","In Scope","Out of Scope") I want to expand it do do other things but have no idea where to start...

hi there, how can i make certain words fall automatically under a category. for example i have spoon, fork, knife, plate, bowl, saucer, i want the first 3 to always specify cutlery in their next column and the last 3 to always specify dishes in their next column any time they are typed the next...

Hi all, I'm looking for some help with a formula ideally (but if VBA is only option I'll accept that). Basically I have a worksheet with data (called Data) in (Columns E to K contain comments boxes which may have lots of words in), and then another worksheet (called Words) with a list of 60...

I have a sheet containing data in A1:CF5364. This will change each time I run this report, there may be more or fewer rows/columns. I'd like to be able to delete an entire row if column P contains one of 9 key words. In this case, the cell would be an exact match but I don't want to limit this...

Stupid question one: Trying to do a formula to add 2 ranges from another workbook. so far I have: =SUM('S:\Data Collection\Stats\School\[St Johns.xlsx]Register'!$C$17:$AH$17) But I also need to add C23:AH27 as well as C17:AH17 Stupid question number two Trying to add the number of words in a...

Hi,, In column A I have very many phrases. Each phrase may or may not have one or more words in brackets. How can I make all the words in brackets written in capital letters? Thank you.

I have column F10 where i have the "Quantity", in each cell, I have a number + cases or each or lbs, or Cases. I want to remove the words, just keep the number. Any help, scripts are welcome. Thank you <tbody> Quantity 1 Cases 1 cases 11 lbs 3 each </tbody>

I would like to populate say column b based on a value in column a. For example column a has credit card data descriptions and I would like to search the column for say a description with the following words "shell" or "exxonmobil" or "chevron", if the words are found then the code assigned...

Hello All, I've been racking my brains trying to shorten a recorded autofilter macro. I recorded the macro 3x's because I have 3 words I need it to find, then it clears entire rows when it finds that word. I want to make it more compact and put all 3 criteria(words) into 1 and not have 3...

Good afternoon I am using the formula below to extract the first 3 words in a cell. Would it be possible to interpret the formula a bit so I can possibly modify- reason, there are some cells which I require to extract the first 4 words. Thanks Gents.... Extract 3...

I am trying to count the items in one column that may include any words from a list of a few key words. Example includes nice, good, great, or excellent. I am looking for a sum total of any occurrences of these words. In addition to these criteria, I only want to count these words if an...

I am trying to count the items in one column that may include any words from a list of a few key words. Example includes nice, good, great, or excellent. I am looking for a sum total of any occurrences of these words. In addition to these criteria, I only want to count these words if an...

Hi all, I was wondering if this would be possible to do, and if so how to apply the correct steps in the power query to achieve it? The Query pulls a certain sheet from a workbook, lets call it sheet1, loads the contents of that worksheet, and then in column 5, IF there is the words "Lathe...

Hello all, I recently watched https://www.youtube.com/watch?v=Tq3B168qT5E and have a question regarding this. My list for example contains these 4 words that i need to use to search for a similar words in a column. admin List 1 unix hrms quality The cells that i am searching for any of...

Hi all, I have the results of a survey which allows people to free-type their answers. I have cleaned the answers up however there are a litany of spelling errors for many of the same words. I need to count the instances of these answers, including the misspelled words. I have a list of the...

Hello All, Can someone please help me how to count specific words in a single cell using formula? Example cell A1 "My computer works fine. I need formula that would count the words computer and works. ​Thanks

Hello, I need help. Need to Check cells with string of words separated by semicolon. The cell is checked against a master list of words on a another tab. Example Cell A1 APPLE;PAIR;TREE;GREEN;ORANGE;HAPPY DATA TABLE APPLE ORANGE PAIR Expected Results based on the master table match Cell...