formatting datatype text

Hi guys,

In versien 6.5 how can I include datatype text in a select statement so that it (later) fits snugly in an Excel grid? So far, I've tried

convert(varchar(50),column_name)

but this is thwarted by carriage returns in the text.

Thanks, Jeff