Forum Discussion
Search for many words in a cell and return exactly the same words if they exist
Hello, I hope you are all well. I want to search about 50,000 words or phrases in one column. If there are any number of these words, I want the exact same words to be returned to me in the opposite ...
You can do this with Power Query as explained in this video.
- Thanks for your response. I can't add the words one by one in the column because there are about 50 thousand words, each word is separated by a comma and it is one after the other in Word. Can I easily enter each word in a column with an operation or function?
=FILTERXML("<t><s>"&SUBSTITUTE(B2,",","</s><s>")&"</s></t>","//s")You can try this formula. In the example the formula is in cell D6. Then i dragged the formula across range D6:D45 and confirmed with ctrl+shift+enter.
The example is for a small number of words. In my understanding it should work for a huge number of words as well.
