Limit the number of characters that a cell contains

I am exporting from Crystal Reports to Excel in CSV format and want to limit
the vendor name to twenty characters. Can anyone tell me how to do that?
Thanks

On Thu, 13 Oct 2005 08:48:03 -0700, "Donna"
<Donna@discussions.microsoft.com> wrote:

>I am exporting from Crystal Reports to Excel in CSV format and want to limit
>the vendor name to twenty characters. Can anyone tell me how to do that?
>Thanks

Why not just let the whole vendor name come into Excel, then use the
string function

=Left(A1,20)

assuming the vendor name is in column A.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________