Limit the number of characters that a cell contains

D

Donna

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
 
R

Richard Buttrey

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
Click to expand...

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
__________________________
 
Top