Formula Engine Reference Guide
 

 

Back to Class Index

 

LEFT(S, N)

Description
This function returns the string composed of the leftmost characters of string S. If N is greater than or equal to the length of S, then the entire string S is returned.
 
Parameters
S

A string value
N
A numeric value
 
Examples
F1 = "workstation"
LEFT(F1, 1) = "w"
 
LEFT(F1, 4) = "work"
 
LEFT(F1, 20) = "workstation"