LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Auto Sizing oranskeer Excel Discussion (Misc queries) 3 December 15th 06 03:24 PM
Putting text in a column based on variable text from another colum Jacky D. Excel Discussion (Misc queries) 1 December 16th 04 06:09 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM
Column Width Deborah M Excel Discussion (Misc queries) 1 December 6th 04 04:27 PM
How do I set up a click "column title" and auto arrange data form. Max Excel Discussion (Misc queries) 1 December 3rd 04 04:44 PM


All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"