Arrow left
Back to guides
Excel Formulas

RIGHT Formula in Excel: Explained

In this article you will learn how to use the RIGHT function in Excel.

What is the RIGHT formula in Excel?

The RIGHT formula in Excel extracts a specified number of characters from the right side of a text string.

When is the RIGHT function useful in Excel?

The RIGHT function in Excel is beneficial when you want to manipulate text data in Excel and can save a lot of time and effort when working with large data sets. Below are a few scenarios where the RIGHT function could be used:

  1. Extracting a specific number of characters from the end of a string.
  2. Pulling out the file extension from a file name.
  3. Taking out the last name from a full name.

How to use the RIGHT formula in Excel?

The general syntax for the formula is as follows:

<pre><code>=RIGHT(text, [num_chars])</code></pre>

The “text” argument is the text string from which you want to extract characters, and the optional “num_chars” argument specifies the number of characters you want to extract, starting from the right.

Note: The “num_chars” parameter must be equal to or larger than zero. When “num_chars” is larger than the length of a text string, the RIGHT function returns the entire text string. If the “num_chars” argument is left blank, the formula considers that it is 1.

Look at the following examples to understand the RIGHT function better.

In this example, C2 contains "apple tree," and the formula would return "ree".

How to use the RIGHT function in Excel with an example

Finally, note that the RIGHT function is case-sensitive, as shown in the screenshot below. So, “liveflow” and “LiveFlow” are considered different by the RIGHT function.

The RIGHT function is case-sensitive in Excel

Analyze your live financial data in a snap in Google Sheets

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows, update numbers in real-time, and save time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. Are you interested in this product but are an Excel user? That’s not a problem at all. You can connect Google Sheets to Excel quickly.

To learn more about LiveFlow, book a demo

Automate any custom financial dashboard in Google Sheets with LiveFlow

You can learn about other Excel and Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below