The LEFT function returns the specified number of characters, starting from the first character in the text.
LEFT( [ Text], [ Number of Characters) ]
Text is the string of text or a reference to some text .
Number of Characters is the amount of characters you want to retrieve, starting from the start of the text.
If the specified number of characters is greater than the total number of characters in the specified text, then when the LEFT function is calculated, it will return the whole text string.
|LEFT(ProductNameComboBoxReturn, 5)||The LEFT function will retrieve the first five characters from the return value of the ProductNameComboBox.|
Number of Characters
Result of the LEFT function
|"Hydraulic Cylinder"||30||Hydraulic Cylinder|