If you use the detailed view in Windows Explorer, or use programs like WinRAR or Winzip or even Excel, you can easily make the column size fit the values of the text details below that column.

Here's an example:
1. Open Windows Explorer
2. Click on View, Details to goto detailed mode
3. Double-click where the indent is between the Name column and Size column

Voila! Your column size automatically changes to the exact size of the largest length of text.