• ANSI Character Functions
• CLNTDIR Function
• CLNTNAME Function
• CURRENCY Function
• DOCPATH Function
• IN Function
• LEFT Function
• LENGTH Function
• LOWER Function
• LTRIM Function
• MID Function
• MKSTR Function
• PRGDIR Function
• RIGHT Function
• SCANSTR Function
• SPACE Function
• STR Function
• SUBSTR Function
• Text Functions
• TITLE Function
• TOKEN Function
• TOKENSUB Function
• TRIM Function
• TRIMRTF Function
• UPPER Function
• XRND Function
• XWKS Function

LEFT Function

The LEFT function selects a specified number of characters starting from the leftmost character of a character expression.

Syntax

LEFT(expression,number)

Example

LEFT("ABCDEF",3)

The cell displays ABC.

Related Topics

• Text Functions