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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
truncate data on cell ?
Enter a space(via spacebar) in each of the adjacent cells.
Actually, enter it in top cell then drag/copy down. Try not to forget you have a space in these cells. Gord Dibben XL2002 On 7 Nov 2003 19:38:43 -0800, (Rich) wrote: 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? |
Reply |
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 |