Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 5 down vote accepted

The formula looks right, but they way you are entering it is probably wrong.

You need to enter this as an array formula, type it in and then press Ctrl + Shift + Enter together rather than just Enter. If you have done it right, the formula in the formula looks like: {=MAX(LEN(A2:A9))}.

(Looked at your link - perhaps I should look at the links before answering in future - yes it's the same thing and still current.)

share|improve this answer
D'oh! That is even on the mrexcel.com site! –  NitroxDM Jul 15 '10 at 20:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.