Excel – Find widest value in range of cells

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.

Cup size   
Select size then click on coffee cup.
This entry was posted in Snippets. Bookmark the permalink.