ExcelBanter - Limit the number of characters that a cell contains

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Limit the number of characters that a cell contains (https://www.excelbanter.com/excel-worksheet-functions/50285-limit-number-characters-cell-contains.html)

Donna

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

Richard Buttrey

On Thu, 13 Oct 2005 08:48:03 -0700, "Donna"
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
__________________________

All times are GMT +1. The time now is 03:17 AM.