limit amount of words...

  • Thread starter Thread starter jonniehiem
  • Start date Start date
J

jonniehiem

i was wondering if it is possible to limit the amount of words you put
in a cell....like say i have a 300 word paragraph...i want to make it
so that wen i put it in a certain cell, it summarize it to 200 words.
is this possible?
thanx,
jonnie m
 
Try Data > Validation
Under Allow: > choose Text length
Data > between
Enter the Min [0] and Max [200], then > OK
 
You could set a limit through Validation that would
restrict the amount of words by counting the number of
spaces between all words. Select the cell (let's use A1),
go to Data > Validation, select Custom in the first box,
and down below enter:

=LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(32),""))<200

HTH
Jason
Atlanta, GA
 
Apologies, mis-read the post.

Scratch the suggestion - meant for
limiting the number of characters, not words

Go with Jason's suggestion ..
 
Back
Top