Excel will automatically extend the LEN function downwards. Excel also lets you be more targeted with your use of TRIMRANGE ...

In a blog post, Microsoft unveiled the TRIMRANGE function. It basically acts as an enhancement to the existing LEN function ... Microsoft does not recommend using it in critical workbooks.