How would one make this formula =MAX(LEN(A2:A9))
work in Excel 2007?
I want the value of the longest field in A2:A9
range.
I found this link: http://www.mrexcel.com/td0021.html, but it's old now.
How would one make this formula I want the value of the longest field in I found this link: 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.) 

