Most valuable professional
  • Hot Topics

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? Reply With QuoteReply With Quote 2. Yesterday, 12:22 AM #2 Michael M View Profile View Forum Posts Private Message Michael M is online now Board Regular Michael M's Avatar Join Date 10/1/2005 Location Western NSW Posts 15452 DefaultRe: Count words between two characters I'm guessing there will be a much better way, but try

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel