This post will guide you how to use **Excel RIGHT function** with syntax and examples in Microsoft excel.

Table of Contents

**Description**

The Excel RIGHT function returns a substring (a specified number of the characters) from a text string, starting from the rightmost character.

The RIGHT function is a build-in function in Microsoft Excel and it is categorized as a Text Function.

The RIGHT function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

**Syntax**

The syntax of the RIGHT function is as below:

= RIGHT (text,[num_chars])

**Where** the RIGHT function arguments are:

**Text**-This is a required argument. The text string that you want to extract from.**num_chars**-This is an optional argument. It will specify the number of characters that you want to extract from Text string.

Note:**Num_chars**value must be greater than or equal to zero. If**Num_chars**is greather that the length of text string, it will return all of text string. If**Num_chars**value is omitted, it is set to be**1**by default.

**Example**

The below examples will show you how to use Excel RIGHT Text function to extract the rightmost substring from a text string.

**#1** To extract the rightmost 4 characters in the B1 cell, just using formula: **=RIGHT(B1,4).**

### More RIGHT Function Examples

- Split Text and Numbers

If you want to split text and numbers from one cell into two different cells, you can use a formula based on the FIND function, the LEFT function or the RIGHT function and the MIN function. .… - Highlight Cells That End with Specfic Characters

If you want to highlight cells that end with a specific text string, you can create a simple formula based on the COUNTIF function to apply conditional formatting. …… - Sorting IP Address

Assuming that you have an IP list of data in the range of cells B1:B5, and you want to sort those IP list from low to high, how to achieve the result with excel formula. You need to create a formula based on the Text Function, the LEFT function, the FIND function and the MID function, the RIGHT function..… - Removing Salutation from Name

To remove salutation from names string in excel, you can create a formula based on the RIGHT function, the LEN function and the FIND function…… - Extract Part of Text String

Assuming that you have a list of data in the range of cells B1:B5, and you want to get the most left 5 characters from cells, or you want to get the most right 4 characters as a substring from cells…… - Insert The File Path and Filename into Cell

If you want to insert a file path and filename into a cell in your current worksheet, you can use the CELL function to create a formual…….. - Extract First or Last N Characters

If you want to extract the first n characters of a sting in a cell in Excel, you can use the LEFT function to create a formula to achieve it. ……..

## Leave a Reply

You must be logged in to post a comment.