How would one make this formula work =MAX(LEN(A2:A9)) in Excel 2007?
I want the value of the longest field in A2:A9
I found this... http://www.mrexcel.com/td0021.html but it's old now.
How would one make this formula work =MAX(LEN(A2:A9)) in Excel 2007? I want the value of the longest field in A2:A9 I found this... http://www.mrexcel.com/td0021.html but it's old now. 


The formula looks right, but they way you are entering it is probably wrong. You need to enter this as an (Looked at your link  perhaps I should look at the links before answering in future  yes it's the same thing and still current.) 

