# Excel RIGHT Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/excel/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 Excel. ```excel =RIGHT(text, [num_chars]) ``` 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 Need more than a single RIGHT formula? Try our free [AI for Excel](https://betteranalyst.com/excel-ai) — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat. ## Parameters **`text`**:\ The text string from which you want to extract the rightmost characters. This can be a text string, a cell reference, or a formula that returns a text string. **`num_chars`**:\ The number of characters you want to extract from the right side of the `text`. This must be a positive integer. If omitted, the default value is 1. ## What is a RIGHT Formula in Excel? The *RIGHT* function in Excel is a text manipulation tool that allows you 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, making it easier to analyze or format data. In simpler terms, the RIGHT function helps you pull out specific characters from the right side of a text string, which can be helpful in various data processing tasks. ## A Practical Example Imagine you have a list of product codes in an Excel spreadsheet, and you want to extract the last three characters from each code to identify the product type. ### Product Codes Table: | Product Code | | - | | ABC123 | | DEF456 | | GHI789 | | JKL012 | | MNO345 | You want to extract the last three characters from each product code. ## RIGHT Formula To extract the last three characters from the product codes, you would use the RIGHT formula as follows: ```excel =RIGHT(A2, 3) ``` ### Breakdown of the Formula: - **A2**: This is the cell containing the text string (product code) from which you want to extract characters. - **3**: This is the number of characters you want to extract from the right end of the text string. ## Result of the Formula When you apply the formula to each product code, it will return the following results: | Product Code | Extracted Characters | | - | - | | ABC123 | 123 | | DEF456 | 456 | | GHI789 | 789 | | JKL012 | 012 | | MNO345 | 345 | Here, the extracted characters are the last three digits of each product code. ## Why Use RIGHT? The RIGHT function is particularly useful when you need to manipulate text data, such as extracting specific identifiers, suffixes, or codes from a larger string. It allows you to streamline data processing and enhance your data analysis capabilities. ## Key Takeaways: - **RIGHT**: Extracts a specified number of characters from the end of a text string. - **Text Manipulation**: Helps you easily retrieve portions of text for analysis or formatting. - **Common Use Cases**: Ideal for processing product codes, IDs, and any scenario where you need to isolate text from the end of a string. Understanding how to use the RIGHT function can significantly enhance your data manipulation skills in Excel, enabling you to work more efficiently with text data. Happy extracting! ## Example use case You have a table where Column A contains product codes, and you want to extract the last three characters of each product code to identify the product category. You can use the RIGHT function to achieve this, allowing for easy categorization and analysis of products based on their codes. This simplifies inventory management and aids in reporting without the need for more complex text manipulation functions. **Beyond the RIGHT function:** Better Analyst is a full [Excel AI](https://betteranalyst.com/excel-ai) that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free [AI Excel assistant](https://betteranalyst.com/excel-ai) that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required. Don't have a spreadsheet yet? Use our free [AI spreadsheet generator](https://betteranalyst.com/ai-excel-spreadsheet-generator) to turn a text prompt into a downloadable Excel file — a full [AI Excel sheet maker](https://betteranalyst.com/ai-excel-spreadsheet-generator) that builds headers, columns, and formulas from your description. ## Need more help with Excel formulas? Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Excel how-to guides - [How To Remove Duplicates In Excel](https://betteranalyst.com/excel/how-to-remove-duplicates-in-excel) - [How To Separate Names In Excel](https://betteranalyst.com/excel/how-to-separate-names-in-excel) - [How To Sort In Excel](https://betteranalyst.com/excel/how-to-sort-in-excel) - [How To Split Cells In Excel](https://betteranalyst.com/excel/how-to-split-cells-in-excel) - [How To Strikethrough In Excel](https://betteranalyst.com/excel/how-to-strikethrough-in-excel) - [How To Subtract In Excel](https://betteranalyst.com/excel/how-to-subtract-in-excel) - [How To Transpose Data In Excel](https://betteranalyst.com/excel/how-to-transpose-data-in-excel) - [How To Unhide Columns In Excel](https://betteranalyst.com/excel/how-to-unhide-all-columns-in-excel) ## Explore all Excel formulas Browse our complete library of Excel 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.