How do I find words in a list of text strings? I would like to do it in excel but if there is some script that will do it that would be nice. Thanks!
You are looking for specific words in a long string? Depending on the language you are using, Regular Expressions work nicely for this. Perl, PHP, Java, C#, VB.NET are some common web server side languages that have RegEx classes.
No, I am looking for a 3 letter word in a series of 3 letter text strings. Could you give specifics on how to do this?
Where are the series of 3 letter text strings? Are the seperate strings in an array object or something, or are they all in the same string seperated by a space or comma? How they are represented will make a difference in finding them. Also, what language are you using / prefer?
if you are interested in Programming a solution, my suggestion would be to export the values in to a comma delimted string, turn the string into an array that you could iterate through to find a match to another string. I am not aware of a ready made tool that will help you better than Excel would in finding strings in an Excel spreadsheet?
I would prefer to do this inside of excel, I put it in programming because I didn't know of another category that would be good for it.