LEFT function

 

The Klipfolio LEFT function returns the first character or a specified number of characters in a text string starting from the first value on the left.

The syntax for the LEFT function is:

LEFT( text, number )

Parameters

text The data set vector
number Optional: The number of characters you want to return scalar

LEFT example

Let's look at a LEFT function example.

 

A

1 Hello World

The following example is based on the above text from an Excel spreadsheet:

LEFT( A:A , 5 ) 

-> [Hello]

Related links: