Hi,

I'm looking for a formula to cut off a text string at either a word limit or perhaps at the end of the closest word to a cutoff value.

"Mary went to the store to shop"

If that is in a cell, what formula in another cell would shorten that after 5 words? "Mary went to the store"

If that is in a cell, what formula would cut it off at the end of the closest word under 20 characters? In this case "Mary went to the"

If that is in a cell, what formula would cut it off at the end of the closest word over 20 characters? In this case "Mary went to the store"

Thank you in advance!