On Thu, 14 Apr 2005 03:11:02 -0700, "supercloudbug"
wrote:

Hi Rowan,

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

=LEFT(A1,20)&IF(LEN(A1)20,"-","")




--ron