Combining List Of Words Into New Words, Conjugation
Feb 15, 2007
I have 4-5 separate lists of words/letters and I would like to combine them in a certain order but creating all possible combinations resulting a new word. It's like a conjugation tool for verbs. For example if List 1 = be/el/ki/meg; List 2= m List3=e/é; List4= gy/" "; List 5=" "/ek/sz/nnek So the output has to be (if the order is List1+List2+List3+List4+List5)= bemegy/bemegyek/bemegysz/bemesz/bemész/elmegy/elmennek/ ..... and all possible combinations.
Preferentially I would like to automate it in a way that it straight outputs into MS Access. Also can it be automated that it reads the list from a file (database)?
(Also can it recognize the word by letters? Because the basic word that I would load the program= List2+List3+List4)
View 2 Replies
ADVERTISEMENT
Feb 13, 2009
I'm looking to take words which are originally in their own separate cells and "combining" the words all into one single cell.
Is there a function that will be able to do this for me?
View 2 Replies
View Related
Sep 20, 2006
I have a column of words in Column A and I want to replace all the times that these words appear in the rest of the excel sheet with the words in Column B. If someone has already answered a similar problem link me to the thread because I can't find anything.
View 5 Replies
View Related
Jun 3, 2014
I'm looking for a macro to remove all words (in a single word per cell format) in a range (approx 100 columns & 7000 rows), except for a list of 100 words.
I'd prefer to email the file if that's okay.
View 7 Replies
View Related
Jul 16, 2009
I've been using conventional method to do this and it's time consuming. I would like to total up 2 column. A multiply B to be exact. Below are some examples:
Table 1 - Before totaling up:
Quantity
Product
5
2 x Button A White
3
4 x Button B Pink
4
5 x Ribbon A Black
2
3 x Thread A White
6
2 x Cloth A Blue
Table 2 - After totaling up:
Quantity
Product
10
Button A White
12
Button B Pink
20
Ribbon A Black
6
Thread A White
12
Cloth A Blue
I need to have the sum of the "Quantity" multiply "Product". Or in short A x B.
And the end result need to have the number and "x" sign removed while keeping on the the products names. (2 x ) Take note it's "number" space "symbol" space.
View 9 Replies
View Related
Jun 23, 2006
I am trying to find certain words in a column and delete the word and characters following. For example, Say I have a column of info as seen below. This is a test of me. I am just experimenting with this stuff. Deleted (6/15/01) Let me know what you think. I am not sure about it all, but I guess I will figure it out. riviledge1 (01/05/06) Now let's see what happens when I try to test it.
I want to find all the "Priviledge1 (01/05/06)" and replace with nothing. Please note, the date will change with each record, so I need to figure out how to tell Excel to find "Priviledge1", delete it and the date behind it. So I want to delete "Priviledge1" and the next 11 characters including the space.
View 3 Replies
View Related
Feb 4, 2013
On to the topic, I have all the US and Canadian states abbreviated (CO = Colorado, etc.) and was wondering if there is a way to make all of them convert to their respective names in one fell swoop instead of writing it in for each one, one at a time. Something along the lines where I can make, CO = Colorado, TX = Texas and then hit enter and all of the abbreviations would convert. Some kind of command.
View 2 Replies
View Related
Jan 22, 2010
I want to sort on number of words, i.e. if a cell contains 1 or 2 words etc, with the cells containing 1 word coming first then cells containing 2 words. Also, if possible, first the cells with fewer characters.
View 9 Replies
View Related
Nov 9, 2006
I have tried Sumproduct and Countif and can not get a proper count of rows that contain specific words in multiple columns. I have attached an example spreadsheet where I am looking for a result of 7 rows that contain 1 to 4 specific words within phrases. The example looks for the words: "virus", "spyware", "malware" & "adaware", and ignores any other words like "aware" or "ware".
View 7 Replies
View Related
Feb 6, 2013
how could i delete numerous words from various entries in excel data list
e.g. salman (Ali) Khan - i want to delete (Ali) from the cell value
View 6 Replies
View Related
Sep 30, 2008
Usually it's to count for one unique word in a cell. But what if I have 2 or more unique word in a cell and need to be counted for?
for example
10827Holiday Decorations & Party Supplyholiday decoration supply10827Holiday Decorations & Party Supplyseasonal decorative
this category has 5 unique words in the synonym list
11044Facial massagerfacial11044Facial massagerbeauty care product11044Facial massagerbeauty appliance11044Facial massagerbeauty11044Facial massagerbeauty care11044Facial massagerbeauty product11044Facial massagerfacial appliance
this category has only 5 unique words although the synonym list is much longer.
View 9 Replies
View Related
Oct 15, 2008
DATA VALIDATION IN MY CODE
Below is my code which looks at Table1 and converts the cell to the appropriate colour when the cell equals the Case
What i would like to do is also have the Case be Data Validation anything else error
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rRow As Range
Dim icolor As Integer
Dim ifont As Integer
With Application
.CellDragAndDrop = False
.CutCopyMode = False
End With
View 9 Replies
View Related
May 1, 2006
I've got a list in "column A" of around 6000 lines which contains key words which I want to extract to "Column b" if It matches but it can match on more than one word .
e.g
List
Six Nations Ireland v England
FA cup Semi Final Chelsea v Liverpool @ Old Trafford
Criteria Sample
Ireland
England
Chelsea
Liverpool
Ideally I would like to extract the first Town/Country as this is where the event is held unless the @ symbol is used then it's the last Toen/Country as in the FA cup example.
View 8 Replies
View Related
May 30, 2008
A friend of mine is playing a computer game, and he has to create 50 different potions to obtain her next goal. She would like to know if it's possible with excel to generate a list of potions based on 7 different elements. Here are the 7 elements : Black orchid, Cactus, Lotus, Pitcher plant, Rose, Tiger lily
Every elements could be repeated to generate one potion.
Therefore, the following combinations are valid :
Cactus - Cactus - Cactus
Cactus - Rose - Cactus
Cactus - Cactus - Rose
Cactus - Rose- Rose
As long as there are no more than 3 elements, it's ok. I'm not looking for the precise coding, I just need to be pushed in the right direction...
View 3 Replies
View Related
Dec 27, 2013
I'm trying to make a game where from a choice of 16 words the contestant has to choose four of those words that, when another word is placed before or after each word it makes a phrase.
e.g From this list of 16 words
albert
bell
[Code]....
choosing bell, bottle, print, stocking can all have BLUE placed before them to make bluebottle, blueprint etc. That would be the correct answer. Choosing their four words would be from a drop down list of all 16 words, separate cell for each list options/chosen answer. bell bottle printstockingCORRECT
There would be 4 rows in total for 4 different answers to be made from the 16 words on offer. I have tried everything to get it to work in the 5th cell but it's difficult.
View 3 Replies
View Related
Mar 19, 2013
I have a big list of words (raw materials). Can I for example use column1 in which if i type one letter a list of words that begin with this letter to come out so i can choose one.
Or I have for example:
Label 1
Label 2
Label 3
And when i type L in cell A1 list of them to be shown and I can choose one.
View 2 Replies
View Related
Dec 6, 2011
I have 15 different words that I want to order in as many ways as possible, but only 3 at a time.
So let's say the words are:
cat
dog
elf
clown
monkey
rock
bananas
(etc)
then I want a list that has all of these possible combinations:
cat dog elf
cat dog clown
cat dog monkey
cat dog rock
cat dog bananas
cat elf clown
cat elf monkey
(etc)
until all are listed. I understand there is a huge number, I don't mind having a couple of thousand as long as they are all genuinely unique.
I CAN have elf dog cat, elf cat dog, dog elf cat later on ... it's just the order that needs to be unique not the words in the phrase.
View 9 Replies
View Related
Jan 3, 2013
it is possible to have a drop down list (Cell A1) where you can type in the first few letters of a word and have the drop down list go to the the words that begin with those first few letters (searching in column 10) instead of having to scroll down the entire list to find the word / item you are looking for.
I ask since the drop down list may end up having up to 1000 words in it.
View 1 Replies
View Related
May 21, 2009
Im hoping there is an Excel Formula (not VBA Code) solution to this problem.
I understand how to use the Substitute command in Excel, but I would like to be able to provide a list of words and have the Substitute command use that list to replace every occurrence within a given cell with a blank ("").
The twist to this is, that the List of Words will be Dynamic, and thus the formula will need to account for that.
NOTE: the formula should NOT replace parts of words, e.g., if the List Word is "can" and the cell to be evaluated contains "candle" the formula should NOT replace the "can" in "candle" with "". Only whole word matches should be replaced.
View 9 Replies
View Related
Feb 26, 2014
I have uploaded my spreadsheet.
I have a column of text strings on Sheet1, Column A, which I need to check for the presence of keywords listed on Sheet2, Column A
So if any word from the keyword list on Sheet2, Column A is found in, say, cell A2 of Sheet1, the cell to its right (B1) should have a formula to display the count of keywords found in A2. I also would like to see each keyword identified either through a highlight or a list. I need the formula to NOT be case sensitive and the match does not have to be for whole words).
View 2 Replies
View Related
May 29, 2005
I have a spreadsheet of part #'s, descriptions, manufacturer names, and manufacturer part #'s. (It's a list of the inventory in my warehouse). Each row contains information for just the item in that row. Row 2 references another part in my warehouse, row 3 yet another, and so on.
Many of the parts have more than one potential manufacturer and part #, (meaning that any of those manufacturer's part #'s are basically the same tool; just different brands. At one time we may get a shipment of one, at other times we may get a shipment of another). For example, a screwdriver may be listed like this:
Part # 1234 screwdriver, mfg Snap-On, part # 456, mfg Stanley, part # 789, mfg Mac Tool, part # 439.
Then further down the list, there may be another part listed like this:
Part # 9980 wrench, mfg Stanley, part #741, mfg Snap-On, part # 852, mfg Proto, part # 369.
If you can imagine that data across the cells of a spreadsheet row, notice how the mfg name 'Snap-On' was the first mfg name on the screwdriver, but it was listed as the 2nd mfg name on the wrench.
So, here's my question: I want to be able to group all of the items made by any one manufacturer together in a new list. If all of the manufacturer names were in the same column, I could simply sort the list by that column, but since I've got thousands of rows with the mfg name I'm looking for in different columns on different rows, I thought maybe a macro could search each row for the word I'm looking for, then if found, take the whole row and copy it to a new worksheet. So the end result would be, If I wanted to see all items of which Snap-On is an acceptable supplier, I could get a list of all potential Snap-On items grouped together.
I'm sorry this is so long. I may have over-worded this and it may not be too clear. I could email an example of the spreadsheet if anyone needed more info to figure out what I'm looking for and was willing to take a look at it.
View 9 Replies
View Related
Jun 25, 2008
I am attempting to take a very large list of keywords, and find the most common words and phrases within them. For example, if I had a list that said:
excel formulas
excel spreadsheet formulas
excel help
excel formulas help form
formulas for excel
I would like to come away knowing that "excel" and "formulas" are common words within the list.
Currently, I believe this can be accomplished by doing the following:
1. Break down each line into all of its possible combinations.This would mean that the line with "excel spreadsheet formulas" would return:
excel spreadsheet formulas
excel spreadsheet
spreadsheet formulas
excel
spreadsheet
formulas
2. Once the entire list is broken down into its many parts, use the pivot table feature of excel to determine how common each of the parts is within the entire data set.
So, my questions are these:
1. Do you believe this is the best way to solve my problem? If not, what would be the preferred method?
2. If this is the best method, what function or script would I use to accomplish the first step of breaking down the lines into their individual parts?
Mike Auto Merged Post Until 24 Hrs Passes;It appears I put too many characters in the title of my post. It should read: Common Words - Decomposing Text Phrases
View 3 Replies
View Related
Dec 5, 2013
I have two lists, one that is 99,000 lines and the other is 150. I am trying to find out where the word(s) in the list of 150 is present in the list 99,000.
1st list of 99,000 is in Sheet1 A1-A99000 and the second list is in Sheet2 B1-B150.
The caveat is that in column A there is additional words in that cell so you can not do a simple vlookup, because there may or may not be an exact match.
I have been stuck for hours and the best i can get is to use the match function but it is not working because it is not exact. Last thing i want to do is use the CTRL F key to lookup all the words.
View 2 Replies
View Related
Apr 27, 2009
I want to be able to lookup if anywhere in a cell contains a word from a list of words, and then provides an output.
Column G:
VAT payment
HMRC payment
Pay VAT
I have a table on the side that shows:
Column Y Column Z
VATHMRC
HMRC HMRC
ie. If anything in column G matches one of the words in Column Y, then output the Column Z. I have use a Vlookup that works for the first two, as VAT is the first thing, but dont know how to make it work if the key word is in the middle of the cell.
View 3 Replies
View Related
Jun 21, 2014
I want to be able copy certain things from cells. Is there a way to make excel copy only the name from cells containing this (One name in each cell):
VESNINA E. (RUS)
PAVLYUCHEN. A. (RUS)
KERBER A. (GER)
I basically want to cut out the (...) in all names. I could do it manually, but there could be quite a few players.
View 3 Replies
View Related
Dec 30, 2008
I'm having a slight problem with lookup. I have attached the workbook. On the worksheet "Time List", it shows each round what time each team plays in order of time. On worksheet "Ind. Times" it is supposed to list the game times in order of team rather than times.
I'm using lookup, but the values in "Ind Times" are incorrect. If you look at the very first value... It says Monday Night Roast have a BYE Round 1, but looking at "Time List" you see they actually play at 8.00pm. On a side note, if I change the values of the team names to numbers - it works no problem at all.
View 3 Replies
View Related
Feb 9, 2009
The Excel function RANK allows one to automatically rank a number within a given range of numbers. Can anyone think of a way to do the same thing with words?
For example, imagine a list of 20 words in a column, with space to add ten more words (complete range B2 to B31, which include the last ten blank cells). If these were numbers, then in the previous column one could simply put in the RANK formula covering the full range, which would then auto update as you added more numbers to the spare ten cells of the range. Assuming that all the values being ranked are unique, and you would therefore get a unique rank number, to order them in rank order, one would simply have the list of possible rank values a column or two removed and VLOOKUP the ranks and their appropriate values.
But what if these numbers were WORDS? The first 20 words are FIXED and will not change, the next ten cells of the range could have any other words typed into them. There is no RANK function for words so how would you suggest that ranking by words is achieved, that does not require any intervention, and as new words were added to the spare ten cells in the range, then the rank would automatically update? This list of ranked words would then be VLOOKUP’d in the same fashion as above with the final list being used to fuel a drop down box, so the user would have an alphabetical listing of all the potential words in the range.
View 7 Replies
View Related
Feb 11, 2010
I m running a weekly league with a money list. There are teams that are randomly drawn each week and the winning team gets a certain amount of money. I want to be able to create a money list that pulls a persons names from my list of winners and tallies up there total winnings from all the tourneys combined.
Here is the data I'm working with:
A B C D
1 Tourney #1 Champ SteveEric $100.00
2 Tourney #2 Champ SteveBen $160.00
3 Tourney #3 Champ GregTony $140.00
4 Tourney #4 Champ GregHarry $70.00
I want it to add up the amount of money won by each player. So for example: Ben has won a total of $80. I want it to read that in my money list, then I would like to be able to sort the list using the DATA sort tool. So my main question is, what formula do I put in the cell in order to find the person's name then pull the amount won for that tournament, divide it by 2, then add it up as a total?
Here is what I want the list to look like:
F G
1 MONDAY NIGHT CORNHOLE MONEY LIST
2 NAMEAMOUNT EARNED
3 Steve$130
4 Eric$50
5 Ben$80
6 Greg$105
7 Tony$70
8 Harry$35
View 5 Replies
View Related
Feb 15, 2013
We are working on a peer review form using Adobe formscentral (quite handy) It will export to excel which is also handy. The problem is, the questions are not 1-5 but are strongly disagree - neutral - strongly agree. However, we still want to be able to "score" people. How do i make a word like "strongly agree" worth 5 points, so i can get a total and average?
View 5 Replies
View Related
Aug 4, 2009
I have a column of Full Names like so:
Tim MacDonald
Pat @ Justine Carey
Penn Fishing C/O Denise Long
Krista Dawkins
Therese le Latshaw
I'm using =LEN(TRIM(C2))-LEN(SUBSTITUTE(C2," ",""))+1 to do a word count. What I need is a formula that will delete all characters between the first and last word if the word count equals more than 2. Even just a formula to determine the location of the first and last space so I can use MID() to cut it out.
View 4 Replies
View Related
