title: Why Does Max Length Formula Throw #VALUE! Error?
body: <p>I have 600 rows of data in Excel and I've copied them to a new worksheet and set the cells as text (also tried general format). When I type the formula below, it doesn't give me the MAX length of data in the column:</p>
  
  <p>=MAX(LEN(A1:A600))</p>
  
  <p>Instead, I'm left with the #VALUE! error. Any thoughts?</p>