How to delete rows that are at least 10 words long?

Please see the excel file attached
Each row has only a single cell, in each cell there is a short sentence.
I need a macro that check each cell and delete the entire row if the total amount of words in it is more than 9 words OR if the total amount of characters is more than 79

Any ideas?

Thx,
Sami

try it

Please Login or Register  to view this content.