View Single Post
  #1   Report Post  
Floyd III
 
Posts: n/a
Default Column character width on auto filter

When auto filter is used on a column, there are rows that are not displayed
in the drop down window. Found that there are about 60 blanks following the
last valid character in the rows that did not display in the drop down
window. This only made the cell contain 85 characters which is far from the
advertised limit. There are only 328 rows also.

Two questions: Is there an easy way to truncate the column to eleminate
the following "0's"? What could have been the cause of them not to
display within the drop down window view under auto filter?

Thanks Floyd III