Skip to main content
Version: Streamsheets 3.0

RIGHT

Excerpts a given number of characters from the right side of a string.

Syntax

=RIGHT(Text, [NumChars])

Arguments

NameTypeDescription
TextStringText to excerpt string from.
NumChars (optional)NumberNumber, which specifies the amount of characters to return.

Default value: 1

Return

TypeDescription
StringExtracted characters from the end of specified Text.

Examples

FormulaResultComment
=RIGHT("SampleText", 3)
"ext"
=RIGHT("Down")
"n"