# Google Sheets RIGHT Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/right-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The RIGHT function extracts a specified number of characters from the end of a text string in Google Sheets. ``` RIGHT(string, [number_of_characters]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the RIGHT you need in plain EnglishGenerate Formula ## Parameters **`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: | Email Address | | - | | | | | | | 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: | Email Address | Domain Name | | - | - | | | example.com | | | domain.com | | | website.org | 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! ## Example use case You have a list of product codes in Column A, and you want to extract the last three characters (representing the version number) into Column B. Using the RIGHT formula, you can easily display the version numbers for quick reference and analysis. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Remove Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-duplicates-in-google-sheets) - [How To Separate Names In Google Sheets](https://betteranalyst.com/google-sheets/how-to-separate-names-in-google-sheets) - [How To Sort In Google Sheets](https://betteranalyst.com/google-sheets/how-to-sort-in-google-sheets) - [How To Split Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-split-cells-in-google-sheets) - [How To Strikethrough In Google Sheets](https://betteranalyst.com/google-sheets/how-to-strikethrough-in-google-sheets) - [How To Subtract In Google Sheets](https://betteranalyst.com/google-sheets/how-to-subtract-in-google-sheets) - [How To Transpose Data In Google Sheets](https://betteranalyst.com/google-sheets/how-to-transpose-data-in-google-sheets) - [How To Unhide Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-columns-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.