What function can you use to return the last character of a string in a cell?

The RIGHT() function is designed to extract a specified number of characters from the end of a string in a cell. When you want to retrieve the last character of a string, you can set the number of characters to be retrieved as 1. For example, if you have a string in cell A1, using the formula RIGHT(A1, 1) will return the last character of that string. This function is particularly useful when working with data where you need to focus on the end of a string, such as in identifying suffixes or last digits in a series of entries.

In contrast, the LEFT() function is used to obtain characters from the beginning of a string, which is not what the question asks for. The MID() function can extract characters from any position within a string but requires knowing the starting position and the number of characters to extract, making it less straightforward for grabbing the last character specifically. Meanwhile, the LEN() function provides the total count of characters in a string rather than extracting characters. Hence, the RIGHT() function is the precise choice for returning the last character of a string.