SharePoint Online Calculated Column LEN Function

In this SharePoint Online tutorial, I will explain how to use a LEN function to calculate the length of a text string in a SharePoint list column by using a calculated column.

SharePoint Calculated Column Length

Now, I will show you how to calculate the length of a text string in the SharePoint Online list calculated column.

LEN function gives the output, i.e., the length of a text string, which means the number of characters in a text string.

LEN function also includes spaces as characters and counts the number of spaces in a text string.

I have a SharePoint list with different data types called “Ally Bank Branches.” Now, I will check the length of a text string based on a column named Branch Name (Title column).

• Open a SharePoint Online list, Click Add column -> Select See all column types and Click on Next.

• Next, on a Create column page, Provide a column name for a calculated column and select the data type as Calculated (calculation based on other columns) as shown below:

• After that, I used the following formula in the formula box to determine how many characters a text string contains in that SharePoint list column.
  • Title – Renamed to Branch Name.
  • In the formula, we have to take it as a Title. we can not find a Branch name from Insert Column.
• Then, Click on Ok.

=LEN(Title)

• Then, it will create a calculated column named ‘Characters Length‘ in a SharePoint Online list as shown below:

• The below image shows ‘Character’s length for the branch name, which is separated by a comma and space (comma and space are also included in a character’s length).

• Then we can see from the below image that a calculated column in a SharePoint list shows the length of a text string (17) which includes three spaces.
  • If it is without spaces, it will show the length of a text string as (14).

This is how to use the LEN function in a SharePoint Online list calculated column.

Conclusion

Through this SharePoint tutorial, I have explained how to use a LEN function in SharePoint calculated column to determine how many characters a text string contains in that SharePoint list column that includes spaces, characters, and text.

You may like:

• SharePoint Calculated Column Current Date
• SharePoint Calculated Column Remove Comma from Number
• SharePoint Calculated Column Round Up
• SharePoint calculated column with a hyperlink