Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LIMIT NUMBER OF CHAR IN A COMBINE CELL | Excel Discussion (Misc queries) | |||
fill or truncate to a certain number of characters in a cell | Excel Worksheet Functions | |||
How do you count number of characters in a single cell | Excel Worksheet Functions | |||
How do you count number of characters in a single cell | Excel Worksheet Functions | |||
Is there a limit to number of words in a cell in excel? | Excel Discussion (Misc queries) |