I have a CSV with more than 200000 words. some of the words are valid english word in dictionary ...some are not.
I want to filter words which are valid only.
Is there any way ?
Thanks
I have a CSV with more than 200000 words. some of the words are valid english word in dictionary ...some are not.
I want to filter words which are valid only.
Is there any way ?
Thanks
How would you determine what is valid and what is not? Remember, excel does not "speak" english, it speaks code
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is a snippet (Macro) that will highlight in red all misspelled words (according to the English dictionary).
Once highlighted, perhaps you could use Conditional Formatting to perform some action on those words ?
It is necessary to highlight the range containing the words to be checked, prior to running this macro.
Please Login or Register to view this content.
Thanks for the Macro. Will check this out.
3 questions .... my excel knowledge is limited.
1. How to run this Macro ?
2. you said highlight the range containing the words to be checked.....how to do that ?
3. Conditional formatting on red ? I just want a fresh list with dictionary words only.
To run an example of how the macro functions ... enter a number of words on Sheet 1. Some spelled correctly, others not so. Then, hold down the left mouse button and drag it across the Sheet so all of the words
are highlighted. Then click the SPELL CHECK button. The misspelled words will be changed to red color.
If you don't understand the process of Conditional Formatting, you can do a web search for EXCEL CONDITIONAL FORMATTING. There are plenty of instructional examples on the net.
There are other methods to delete the misspelled words as well: another macro (code) that will delete the words; or cut / paste those words to another Sheet for review, etc.
I suggest you play around with the options and review the various instructions on the internet. When you have settled on what you want to do with the misspelled words, start another THREAD on this Forum and ask for assistance.
It is always best to include an example file with your request, showing what you have accomplished so far and what your ultimate goal is.
Hope this helps.
(If this takes care of things for the time being, please mark this thread SOLVED. Up top, right side "THREAD TOOLS")
ps: Thanks for the add rep.
Last edited by Logit; 12-30-2016 at 11:11 AM.
zerodegree
I was just reviewing the attachment here and discovered an error. This new attachment functions pretty much the same way except it highlight the entire cell where the misspelled word
is located ( highlight in blue ). Also, no need to highlight the words prior to running the macro. Simpler !
Thanks.
Ok .... got it straightened out. Here is a multi-purpose spell checker with color highlighting.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks