Here is an excel tip for finding the maximum width/length of values in a range of cells. It is useful when converting spreadsheets to databases where you need to define the data attributes.
Type the following including braces into a cell adjusting the range values to your actual range of data. (DO NOT HIT ENTER)
{=MAX(LEN(A5:A100))}
Press CTRL + Shift + Enter to make the formula display the value of the widest row.
