Microsoft Excel Formulas: LEN

LEN is a simple formula that is not often used, however, used correctly it can be used to simplify your workbooks

 

LEN Syntax

LEN returns the length of a string in a cell. The Syntax is very simple:

=LEN (text)

Why is LEN Useful?

On its own, LEN may not seem that useful. There are many scenarios that using LEN can make your life easier. A couple of which are:

  • You know that only strings with length x are needed for the piece of work that you are doing
    • Insert a helper column and use LEN to return the string length of each cell then use a filter to remove the unnecessary data
  • Only entries of a certain length need a calculation performing
    • Use LEN with an IF formula as the ‘logical test’ to determine the length of each entry

 

Watch Out

When using LEN number formatting is not included. For example, £50.00 will still show as ‘2’

LEN

 

If you’ve found this article interesting and or useful please share it on social media using the handy share buttons

Subscribe to our mailing list to be the first to know when new articles are published

At Happy Duck we build bespoke business and financial management tools for small, medium and large companies that help them achieve their goals. This makes us happy. Find out more about us and about our services.

More in Excel Basics

0 Comments

Leave a comment

Your email address will not be published. Required fields are marked *