Google Sheets RIGHT Function: Syntax, Examples & Tips

string:
The text string from which you want to extract the rightmost characters.

number_of_characters:
The number of characters you want to extract from the end of the string. If omitted, it defaults to 1.

What is a RIGHT Function?

The RIGHT function in Google Sheets is a simple yet effective tool used to extract a specified number of characters from the end of a text string. This function is particularly useful when you need to retrieve a portion of text that is located at the end of a string, such as file extensions, last names, or any other data where the relevant information is positioned at the end.

In simpler terms, RIGHT allows you to take a specific number of characters from the right side of a text string, making it easy to manipulate and analyze text data.

A Practical Example

Imagine you have a list of email addresses stored in a Google Sheets spreadsheet:

Email Table:

You want to extract the domain names from each email address.

RIGHT Formula

To achieve this, you would use the RIGHT function in combination with the FIND function to locate the position of the "@" symbol. Here’s how you can do it:

 =RIGHT(A2, LEN(A2) - FIND("@", A2))

In this formula:

• A2 is the cell containing the email address.
• FIND("@", A2) finds the position of the "@" symbol in the email address.
• LEN(A2) calculates the total length of the email address.
• LEN(A2) - FIND("@", A2) gives the number of characters to extract from the right side of the string.

Result of the Formula

When you apply the RIGHT formula to the Email Table, the output would look like this:

The RIGHT function effectively extracts the domain names from each email address.

Why Use RIGHT?

The RIGHT function is beneficial because it simplifies the process of extracting specific portions of text from strings. It allows for quick and efficient data manipulation without the need for complex formulas. This can be particularly useful in data cleaning and preparation tasks.

Key Takeaways:

• RIGHT: A straightforward function that extracts a specified number of characters from the end of a text string.
• Text Manipulation: Ideal for scenarios where relevant information is located at the end of a string.
• Combining Functions: Can be used in conjunction with other functions like FIND and LEN for more complex text extraction tasks.
• Common Use Cases: Useful for extracting file extensions, domain names, last names, and any other text data where the relevant information is at the end.

The RIGHT function is an essential tool for anyone working with text data in Google Sheets, providing a simple way to enhance data analysis and reporting capabilities.

Happy spreadsheeting!