Hi all.
Would you please help me with the following problem.
I am using Excel 2016.
I have a script, consisting of a few hundred pages, in a foreign (for me) language.
I have separated each word (number) into a separate cell, and numbered them. Column A.
I also created a list of possible meanings for each word. Column B.
Because words appear frequently in every sentence, I am faced with the problem of pairing (matching) each word in each sentence, with the possible meaning.
Thank you
Kobus.
Would you please help me with the following problem.
I am using Excel 2016.
I have a script, consisting of a few hundred pages, in a foreign (for me) language.
I have separated each word (number) into a separate cell, and numbered them. Column A.
I also created a list of possible meanings for each word. Column B.
Because words appear frequently in every sentence, I am faced with the problem of pairing (matching) each word in each sentence, with the possible meaning.
Word Numbers | Word meaning | Pair Numbers with Meaning |
1 | A | 1A |
1 | B | 1A |
1 | C | 1A |
2 | D | 2B |
2 | E | 2B |
3 | F | 3C |
3 | G | 3C |
3 | H | 3C |
4 | I | 4D |
4 | J | 4D |
Thank you
Kobus.