LEN of multiple cells in a column

[teachman]

Hello,

I need to determine the maximum length of a text entry in a series of cells in a column. Is there a way to do this spreadsheet mode? I suppose I could write a macro for it, but, I'm lazy and hoped to find a way without coding.

Thanks,
George Teachman

 

[sheetspread]

If you just want the length:

Excel 2010
	A
2	fdgfjhhj
3	sdsdgfghhjkjlj
4	rere
5
6	q
7
8	werytuiuioi
9	fdfdbvvbvbnbnbnbgf
10
11
12	18
Sheet10

Cell Formulas
Range	Formula
A12	{=MAX(LEN($A$2:$A$9))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[teachman]

Thanks, just what I was looking for.