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 )


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.



1 Hello World

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

LEFT( A:A , 5 ) 

-> [Hello]

Related links: