How to Use Excel Right Function in Office 365? – With Example!!
Tags: excelfunctions, rightfunctioninexcel, excel, exceltutorials
Published: 2020-12-14 12:19:13

---
title: How to Use Excel Right Function in Office 365? – With Example!!
published: true
date: 2020-12-11 05:10:43 UTC
tags: ExcelFunctions,RightFunctioninExcel,Excel,ExcelTutorials
canonical_url: https://geekexcel.com/how-to-use-right-function-in-microsoft-excel-365/
---

## Right Function in Excel:

If you want to extract the characters from the right side of a text string, then **Right Function** will be the right choice to use in Excel. It is a built-in function and categorized under [**TEXT Functions**](https://geekexcel.com/list-of-text-functions-in-microsoft-excel-365/).

This article gives you an illustration of the **explanation, basic syntax, and usage of the Right function** in Excel Office 365.
## **Description of Right Function:**

- The **Right Function** in Excel is used to **extract the texts with the given number of characters from the right side.**

## **Basic Syntax of Right Function:**

```
**=RIGHT(text,[num\_chars])**
```

### **Argument Description:**

- **Text** – Extract the texts with the given number of characters from the right-side direction.

## **Right Function – Practical Examples:**

Now Let’s grasp some examples of the **Right**  **function** and explore how it works in Microsoft Excel.

### Example 1:

- The input text is entered in the **Cell B6**
- The formula is entered in the output **Cell E6** , to calculate the output.
- Below screenshots are the **two ways** of using the formula in the cell.

![formula 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_1-22.png)<figcaption id="caption-attachment-4480">formula 1</figcaption>

![Formula 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_2-19.png)<figcaption id="caption-attachment-4481">Formula 2</figcaption>

- Press enter to display the **output**.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_4-16.png)<figcaption id="caption-attachment-4482">Output</figcaption>

- Here the above screenshot is explaining the Right Function in Excel, i.e. the right side of the text has been your result.

### Example 2:

- In this example, the Right Function **extracts the texts** with the **given number of the characters from the right-side direction.**
- Refer to the below screenshot to **identify the formula**

![formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_3-19.png)<figcaption id="caption-attachment-4486">formula</figcaption>

- The **output** will be display by pressing the enter key.

![output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_5-11.png)<figcaption id="caption-attachment-4487">output</figcaption>

## Closure:

This article gives you clarification about the **explanation, basic syntax, and usage** of the **Right Function** with a few practical examples. Kindly drop your valuable **suggestions/queries** in the comment box & Don’t forget to drop your **worthwhile Feedback**.

Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning with us!!

## Related Articles:

- **[YEAR Function in Excel ](https://geekexcel.com/how-to-use-year-function-in-excel-365/)**
- **[EDATE Function in Excel](https://geekexcel.com/how-to-use-edate-function-in-excel-365/)**
- [**MINUTE Function in Excel **](https://geekexcel.com/how-to-use-minute-function-in-excel-365/)
- [**WORKDAY Function in Excel **](https://geekexcel.com/how-to-use-workday-function-in-excel-365/)
- **[DATE Function in Excel](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)**
- [**LOWER Function in Excel **](https://geekexcel.com/how-to-use-lower-function-in-microsoft-excel-365/)
- [**NETWORKDAYS Function in Excel **](https://geekexcel.com/how-to-use-networkdays-function-in-ms-excel-365/)
- [**SUM Function in Excel **](https://geekexcel.com/sum-function/)
- [**YEARFRAC Function in Excel**](https://geekexcel.com/how-to-use-yearfrac-function-in-microsoft-excel-365/)
- [**CODE Function in Excel **](https://geekexcel.com/how-to-use-code-function-in-microsoft-excel-365/)
- [**DAYS360 Function in Excel **](https://geekexcel.com/how-to-use-days360-function-in-excel/)