simply append

&" - "

to the end of Roowan's formula



"supercloudbug" wrote:

Hi Rowan,

Thanks for your help.
Do u think its possible to end the shortened sentence with a "-"?

"Rowan" wrote:

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?