RIGHT function

The Klipfolio RIGHT function returns the last character or a specified number of characters in a text string starting from the last value on the right.

The syntax for the RIGHT function is:

RIGHT( text, number )


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

RIGHT example

Let's look at a RIGHT function example.



1 Hello World

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

RIGHT( A:A , 5 ) 

-> [World]

Related links: