| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I limit the number of complete sentences in a spreadsheet c
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. |
|
#2
|
|||
|
|||
|
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. -- nbrcrunch |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I limit number of rows and columns on a spreadsheet | New Users to Excel | |||
| limit number of characters in a cell | Excel Discussion (Misc queries) | |||
| How do I limit the number of times an Excel workbook can be opene. | Excel Discussion (Misc queries) | |||
| updating invoice number on excel spreadsheet | Excel Worksheet Functions | |||
| How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
Linear Mode
