RIGHT

Formula Explanation

Return the last 'n' characters of a string.

Formula Syntax

Enter in the result column: right("text to process", number of characters to return)
  • You can use column references as parameters, i.e., the CODE at the top of each column in the table, e.g., AA1.

Usage Example

Get the last 4 characters of column EE2 and write the result in column EE3.

EE3 = right(EE2, 4)

right

Last Updated: