Hello,
I do quite a bit of work with excel for my job, but this is a task I am stumped on.
I have millions of lines of data, and I am looking for words within text strings. There are no spaces, and many of the lines are gibberish (random numbers and letters together), while some contain words concatenated together.
I don't necessarily need excel to tell me what these words are (few cells are over 20 units in length), but I do want to know which cells contain one or more english words so I can sort them to the front of my list for manual inspection.
Can anyone please help me with this?
I do quite a bit of work with excel for my job, but this is a task I am stumped on.
I have millions of lines of data, and I am looking for words within text strings. There are no spaces, and many of the lines are gibberish (random numbers and letters together), while some contain words concatenated together.
I don't necessarily need excel to tell me what these words are (few cells are over 20 units in length), but I do want to know which cells contain one or more english words so I can sort them to the front of my list for manual inspection.
Can anyone please help me with this?
