How would one make this formula
=MAX(LEN(A2:A9)) work in Excel 2007?
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.)