Hey Guys, I am in need for some Help.
I have a workbook with a lot of text and words in different cells, all in one column. There are hundreds of cells, all in one column, and each cell has many different words. I need to extract each word from this cells, and list them sepparately and individually: One word per cell, all in one column, and i don´t know how to do that!
After that I need to count how many appearences each word has, but I know how to do that with formulas, once I have the list extracted from the original column.
I found this thread, which seems to solve all my problems, but it is old, and it is made for windows, so I cannot make it work:
I appreciate if someone can help me with this, either with formulas or VBA. If it is VBA, I appreciate if you can help me out with a step-by-step for mac, since I am not really familiar with VBA or macros.
Thanks a lot!
I have a workbook with a lot of text and words in different cells, all in one column. There are hundreds of cells, all in one column, and each cell has many different words. I need to extract each word from this cells, and list them sepparately and individually: One word per cell, all in one column, and i don´t know how to do that!
After that I need to count how many appearences each word has, but I know how to do that with formulas, once I have the list extracted from the original column.
I found this thread, which seems to solve all my problems, but it is old, and it is made for windows, so I cannot make it work:
Formula for > 1. Listing all unique Words in a Cell Range alphabetically, then > 2. Listing the Total Count for each Word
A B C 1 CELLS WITH TEXT TO BE COUNTED Alphabetical WORD LIST from Column 'A' CELLS WORD COUNT from Column 'A' 2 Test text in here Even 1 3 More test text here Final 1 4 Even more text here here 4 5 Final test text here in 1 6 more 1 7 More 1 8 test 2 10 Test 1 11 text...
www.mrexcel.com
I appreciate if someone can help me with this, either with formulas or VBA. If it is VBA, I appreciate if you can help me out with a step-by-step for mac, since I am not really familiar with VBA or macros.
Thanks a lot!