Excel: Count words between two characters


What I'm trying to achieve is that if there is a text in A1 like this Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus ut lectus est. Pellentesque cursus ut ipsum sed commodo. Mauris ullamcorper, odio ultricies scelerisque dictum, quam mauris dapibus justo, sit amet ornare est urna at risus. Quisque sodales euismod nunc a vulputate. I want to put in B1 a message that says "Sentence too long" if one or more of the sentences in A1 has more than 15 words. Is it possible to count the number of words between multiple periods in a cell?


This question generated 18 answers. To proceed to the answers, click here.

This thread is current as of July 27, 2017.


For more resources for Microsoft Excel