Which function returns a substring from the right of the string?

The function that returns a substring from the right side of a given string is the Right function. This function allows users to extract a specific number of characters starting from the right end of the string. It is particularly useful when you need to obtain data such as a specified number of trailing characters, which can be essential for various data manipulation tasks.

For example, if you have a string that represents a code, and you only want the last few characters—perhaps to extract version numbers or identifiers—the Right function serves this purpose effectively by specifying how many characters to return.

The other functions listed do not provide this specific functionality. The Replace function is for changing specific parts of a string with another string, TextBetween focuses on extracting text between specified delimiters, and Capitalize changes the case of letters in a string but does not deal with substrings. Thus, the Right function is distinctly designed for retrieving the last segment of a string, making it the correct choice in this context.