Home > Reference > Functions reference > Text functions > RightWords
RightWords Purpose Returns a text result containing the numberOfWords in text, counting from the right. Format RightWords(text;numberOfWords) Parameters text - any text expression or text field numberOfWords - any numeric expression or field containing a number Data type returned text Examples RightWords(“Plaid Canvas Suitcase”;2) returns Canvas Suitcase. RightWords(Name;1) returns Virtanen, when the Name field contains Matti Virtanen. Note The ampersand (&) and hyphen (-) characters identify the beginning of a new word. Related topics Functions reference (category list) Functions reference (alphabetical list) About formulas About functions Defining calculation fields Using operators in formulas