Fabric Plan Community Logo
Sign in

LEN

Returns the number of characters in a text string, including spaces and special characters.

The LEN function returns the total number of characters in a text string, including letters, numbers, spaces, and special characters. This function is commonly used to measure text length, validate input, and prepare data for further processing.

Syntax

LEN(text)

Arguments

  • text: The text string or reference whose length you want to calculate.

Return value

Returns the total number of characters in the text string.

Example

LEN([Product Name])

Calculates the number of characters in each value of the Product Name field, including spaces and special characters.

Excel equivalent

LENGTH

Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.