Limit the number of characters that a cell contains

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Custom Filtering - Limitations of the "Contains" option 7
Hightlight cells that contain special characters 13
Limitations on Sumif Calculation 3
LIMIT THE NUMBER OF CHARACTERS ENTERED IN A FIELD 2
Red cell for negative numbers in Excel 1
How to limit the characters in a cell 1
Lower-Case Characters 2

Back
Top