I probably need more information to determine exactly what you requre but
have a look at this anyway.

If you have the text "This is my sentence" in cell A1 then
=Left(A1,10) will return "This is my".

Hope this helps
Rowan

"supercloudbug" wrote:

Hi,

Any one can teach me if there's any formula, macro or add-in to shorten
sentences to a specific length?