title: determine the cell holding the longest string with excel
body: <p>I'm trying to find which, cells hold the longest string in an excel spreadsheet.</p>
  
  <p>I'm using the formula below to determine the length of the longest string</p>
  
  <pre><code>MAX(LEN(A2:A2000)) 
  </code></pre>
  
  <p>But here I'm stuck because I have no idea where to find this cell.</p>
  
  <p>I don't want to go into a macro routine because it is a one-off job. However, if there is nothing else to do, well ... I'm ok to follow that route.</p>
  
  <p>I'm all ears to your ideas.</p>
  
  <p>Best.</p>