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.

How to generate random text using the RANDARRAY() function in Excel Your email has been sent Image: PixieMe/Shutterstock Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft Systems ...