How do I limit the number of complete sentences in a spreadsheet c

S

sbernard

I'm trying to keep the number of complete sentences to the maximum number
within a 400 character limit. I understand how to use LEN to limit the
number of characters, but don't get how to take the resulting cells that have
incomplete sentences and delete the partial sentence at the end.

Any advice would be appreciated.
 
N

nbrcrunch

If cell A1 contains:
This is a test. This is

and cell A2 contains the formula:
=MID(A1,1,FIND(".",A1,1))

The result will be:
This is a test
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Number of Unique Cells That Don't Have Certain Characters 0
How Do I Replace Paragraphs With New Paragraphs In Excel? 8
Multiple selections in a single cell - How? 14
How do I limit formula results to positive only? 4
Truncating a cell entry to the last full word 4
Challenge - How do I make a bullet style where the first word isbold? 2
How do I extract the decimal places from a number in excel? 3
Detailed formatting problem 0

Top