Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
truncate data on cell ?
I am using Excel 97.
I have a spreadsheet where there is a column that contains comments typed in by the users. These comments can be a sentence long. The comments tend to spill into the neighbor cells. If I use the mid command, I chop of data. If I use word wrap, the spreadsheet can look real ugly with very large cells. Is there something that I can do other than word wrap that will stop the data from spilling into the other cells? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Truncate a data entry cell | Excel Discussion (Misc queries) | |||
Truncate within a cell | Excel Worksheet Functions | |||
can i write a macro to truncate alpha-numeric data? | Excel Discussion (Misc queries) | |||
how do i truncate text-- create cell with only 125 charecters | Excel Worksheet Functions | |||
truncate the yaxis if one data point is MUCH higher than the rest | Charts and Charting in Excel |