Fabric Plan Community Logo
Sign in

LEFT

The LEFT function returns the specified number of characters from the beginning of a text string. When used with a number, the function returns the result as text.

Syntax

LEFT(text, num_chars)

Arguments

  • text: The text string that contains the characters to extract.
  • num_chars: The number of characters to extract from the beginning of the text.

Return value

Returns the specified number of characters from the left side of the text string.

Example

LEFT([Full Name], 4)

If Full Name contains Johny Rivers, the function returns John.

Excel equivalent

LEFT

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.